/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 vote265 views1 answer
Do you know sql
SQL
-1 vote273 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote248 views1 answer
Oracle query to see what scema i am working in
SQL
2 votes275 views1 answer
Power query concatenate
SQL
0 vote269 views1 answer
Mysql select inside sum
SQL
0 vote270 views1 answer
Mysql undo delete
SQL
0 vote281 views1 answer
Hashpass
SQL
0 vote262 views1 answer
Regex mongoose
SQL
1 vote255 views1 answer
Add current timestamp in mysql
SQL
0 vote251 views5 answers
Linq cheat sheet
SQL