/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 vote184 views1 answer
Sql find all different values in column
SQL
0 vote197 views1 answer
How to inner join 4 tables in sql
SQL
3 votes197 views3 answers
1396(hy00) mysql error
SQL
1 vote176 views2 answers
Find nth highest salary of an employee
SQL
0 vote170 views1 answer
Find and replace database table phpmyadmin
SQL
-1 vote210 views4 answers
Full outer join in sql
SQL
1 vote166 views1 answer
Mysql get latest duplicate rows
SQL
2 votes166 views1 answer
How to check grants on a package in oracle
SQL
19 votes158 views6 answers
Laravel sql query
SQL
1 vote187 views1 answer
Replace all numbers in mysql
SQL