mysql connector errors interfaceerror caching_sha2_password requires ssl on mysql connector python code example
Example: 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'
)