/SQL/Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

You have probably installed mysql-connector instead of mysql-connector-python. So you need to install it again for python3:

pip3 install mysql-connector-python

Source: stackoverflow.com

Mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

#To resolve this error just add auth_plugin 
import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="username",
  password="password",
  database="db name",
  auth_plugin='mysql_native_password'
)

-2

Similar codes

12 votes349 views4 answers
Mysql get date difference in hours
SQL
0 vote330 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote362 views1 answer
Mysql listing get a particu particular user firsdt
SQL
1 vote341 views1 answer
Oracle sql create view
SQL
0 vote359 views1 answer
Full outer join in mariadb mysql
SQL
0 vote372 views5 answers
Mode sql course
SQL
1 vote363 views1 answer
Get create table query existing table mysql
SQL
2 votes360 views1 answer
Removing view
SQL
1 vote386 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote332 views1 answer
How to fetch highest score in minimum time using mysql
SQL