/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 vote298 views1 answer
How to get initials in sql
SQL
0 vote287 views1 answer
Automate mysql cli query
SQL
1 vote304 views1 answer
Postgres set column equal to another
SQL
0 vote261 views1 answer
Sql select rows with simlar names
SQL
2 votes282 views1 answer
Mysql auto increment jumping
SQL
0 vote302 views1 answer
Recover deleted data from mysql database
SQL
2 votes356 views1 answer
Sql find not in list
SQL
4 votes309 views2 answers
Show all database inside postgresql
SQL
3 votes312 views1 answer
Sql online test questions and answers
SQL
0 vote297 views1 answer
How to print records of employees hired in particular month in oracle
SQL