/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

0 vote223 views1 answer
How to reset AI in sql
SQL
0 vote267 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
3 votes228 views1 answer
Oracle revoke
SQL
1 vote230 views1 answer
Sample clause in sql
SQL
5 votes275 views1 answer
Add column table sql default value
SQL
1 vote226 views1 answer
Sample in sql
SQL
2 votes225 views1 answer
Date_format for time sql
SQL
1 vote235 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote254 views1 answer
Ms sql print more than 1 variable
SQL
0 vote261 views1 answer
Oracle string length
SQL