/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 vote160 views2 answers
Plan d'exécution requete oracle autotracer
SQL
1 vote152 views1 answer
Restart identity postgresql
SQL
0 vote164 views1 answer
Delete hangfire retries list
SQL
0 vote151 views1 answer
Groupby error in mysql
SQL
0 vote148 views2 answers
Update information in a mysql column
SQL
2 votes160 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote161 views1 answer
Sql remove last 2 digit
SQL
0 vote214 views2 answers
Mysql cast to varchar
SQL
0 vote168 views1 answer
Add mysql database to power bi web
SQL
1 vote147 views1 answer
Set statistics on in ssms
SQL