/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

8 votes376 views2 answers
Sqlsrv default port
SQL
0 vote371 views1 answer
Enable sql server full text indexing
SQL
0 vote392 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote350 views1 answer
Sql row number in result set
SQL
0 vote362 views1 answer
Postgres execute multiple sql file from command line
SQL
1 vote367 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote359 views1 answer
Minus equivalent in my sql
SQL
7 votes351 views1 answer
Sql management studio display line numbers
SQL
2 votes366 views4 answers
List databases in sql server
SQL
0 vote387 views1 answer
Sql create and grant user access to database
SQL