raise errors.NotSupportedError(mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported code example
Example 1: 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
Example 2: mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="username",
password="password",
database="db name",
auth_plugin='mysql_native_password'
)