/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

1 vote114 views1 answer
Index a database column sql
SQL
0 vote135 views3 answers
How to run sql query
SQL
0 vote85 views1 answer
Bigquery information_schema schema all columns
SQL
2 votes115 views2 answers
How to get capital letter first in sql
SQL
1 vote116 views1 answer
Postgresql export output table as a csv
SQL
3 votes128 views2 answers
Mysql time
SQL
8 votes122 views1 answer
Today minus 15 days postgresql
SQL
0 vote128 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
6 votes139 views3 answers
What is where in sql
SQL
10 votes125 views5 answers
Mysql create user
SQL