/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

2 votes208 views1 answer
Sql skip the first row
SQL
1 vote200 views1 answer
Sql how to duplicate a table
SQL
2 votes202 views2 answers
Mysql find max value row
SQL
4 votes213 views2 answers
Dbms output
SQL
3 votes217 views3 answers
1396(hy00) mysql error
SQL
2 votes193 views1 answer
Mysql trigger after update
SQL
1 vote199 views2 answers
T sql get foreign key
SQL
8 votes197 views1 answer
Script to add datafile to tablespace
SQL
9 votes198 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote221 views1 answer
Oracle string length
SQL