/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

25 votes353 views5 answers
Date in mysql
SQL
0 vote359 views1 answer
Running percentage of total postgres
SQL
1 vote356 views2 answers
Backup table mssql
SQL
44 votes440 views4 answers
Mysql alter table add column first
SQL
8 votes371 views2 answers
Between operator
SQL
0 vote354 views1 answer
SQL Where-Klausel
SQL
3 votes644 views1 answer
Postgresql cast
SQL
0 vote365 views1 answer
Rename constraint postgresql
SQL
13 votes347 views4 answers
Command line mysql import
SQL
0 vote327 views1 answer
Mysql select last 15 minutes
SQL