/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

2 votes353 views1 answer
Clock in python
Python
0 vote354 views2 answers
Python - Comment jouer le fichier Mp3
Python
2 votes343 views4 answers
Python repr()
Python
11 votes318 views2 answers
How to find the position in a list python
Python
13 votes303 views2 answers
Python last letter of string
Python
0 vote297 views2 answers
Mountain array leetcode
Python
0 vote318 views1 answer
Qdate to date
Python
0 vote349 views1 answer
How to install python packages in local directory
Python
1 vote288 views1 answer
Get int value of char python
Python
0 vote400 views2 answers
Np.exp in python numpy
Python