/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 vote150 views1 answer
How to move a column to different spot mysql
SQL
0 vote135 views1 answer
Write sql query to show the details start from digit
SQL
1 vote152 views1 answer
Oracle compile schema
SQL
0 vote142 views1 answer
Mysql date only no time
SQL
1 vote132 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
49 votes226 views6 answers
Install mysql ubuntu
SQL
79 votes323 views6 answers
Grepper code
SQL
1 vote129 views1 answer
Woocommerce mysql price table
SQL
1 vote131 views1 answer
Sql restore backup query
SQL
2 votes132 views2 answers
How to check database username and password in postgresql
SQL