/SQL/Raise errors.NotSupportedError( 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 vote170 views1 answer
C# sql transaction multiple connections
SQL
0 vote137 views1 answer
T sql cursor tr
SQL
1 vote98 views1 answer
Oracle boolean to varchar
SQL
0 vote139 views1 answer
Mysql count by month
SQL
0 vote158 views1 answer
Check database restore status sql script
SQL
20 votes179 views4 answers
How to find average in sql
SQL
0 vote134 views1 answer
Restore backupfile discourse
SQL
0 vote136 views1 answer
Postgres float to int
SQL
0 vote97 views2 answers
Sql query unique
SQL
0 vote132 views1 answer
Flask sqlalchemy update row
SQL