/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

0 vote182 views1 answer
For in list start with index python
Python
1 vote207 views1 answer
Pythin load .csv
Python
2 votes188 views1 answer
Install telethon
Python
0 vote156 views1 answer
Airindia
Python
0 vote184 views1 answer
Python linter
Python
0 vote182 views1 answer
Python remove blanks from string
Python
0 vote202 views1 answer
Python create type for heterogeneous dict
Python
2 votes281 views4 answers
Numpy reshape (n ) to (n 1)
Python
0 vote245 views1 answer
Python kdtree import
Python
0 vote182 views1 answer
Deques in python3
Python