/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

22 votes139 views4 answers
Mysql format date
SQL
1 vote130 views1 answer
Sql server loop over query
SQL
0 vote107 views1 answer
Create table in dbms cmds
SQL
0 vote113 views1 answer
Sql query to find duplicate email address
SQL
0 vote129 views1 answer
Sp help text in postgresql
SQL
0 vote104 views1 answer
Phpmyadmin tabellentyp ändern
SQL
3 votes108 views1 answer
Get all elements sql
SQL
12 votes136 views6 answers
Distinct in sql server
SQL
2 votes121 views1 answer
Show max_allowed_packet mysql
SQL
6 votes101 views1 answer
Oracle trigger after logon on schema
SQL