/Python/Mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

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

4 votes187 views4 answers
Python hex
Python
0 vote183 views1 answer
How to decode recv data in python
Python
0 vote197 views2 answers
Pyspark parquet to dataframe
Python
0 vote212 views1 answer
Take first n row of dictionary python
Python
8 votes213 views3 answers
Export multiple python pandas dataframe to single excel file
Python
0 vote177 views1 answer
How to make a new column with explode pyspark
Python
-1 vote179 views6 answers
Pandas show column with regular expression
Python
15 votes204 views2 answers
Read excel into dataframe python
Python
3 votes218 views10 answers
Date parser python pandas
Python
1 vote210 views1 answer
Display 2d numpy array as image
Python