/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 vote158 views2 answers
Nodejs mysql convert to plain object
SQL
8 votes149 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote151 views1 answer
Python mysql show databases
SQL
3 votes158 views1 answer
Oracle get trigger ddl
SQL
1 vote157 views2 answers
Insert sqlite
SQL
1 vote149 views1 answer
Sql get missing id
SQL
0 vote151 views1 answer
Sql query to force the database to be drop
SQL
1 vote156 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote141 views1 answer
List mysql tables and views
SQL
0 vote134 views1 answer
Drop all tables in azure sql database
SQL