/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 vote193 views1 answer
Mysql update sum same table
SQL
15 votes195 views4 answers
Mysql where value is null
SQL
5 votes220 views1 answer
Oracle list packages
SQL
8 votes212 views1 answer
Show mysql user table
SQL
0 vote191 views1 answer
How to connect postgresql database with java
SQL
9 votes204 views3 answers
Mysql get last id
SQL
2 votes197 views2 answers
Created at and updated at in mysql
SQL
7 votes210 views4 answers
Index in mysql
SQL
5 votes200 views1 answer
Oracle nls session
SQL
0 vote213 views1 answer
Recently updated stored procedure in sql server
SQL