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
3.67
3
#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'
)
Thank you!
3
0
Are there any code examples left?
New code examples in category SQL