/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 vote110 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote98 views1 answer
Java input type sql date
SQL
0 vote105 views1 answer
Execut sql python
SQL
1 vote107 views1 answer
Oracle start job
SQL
0 vote114 views2 answers
Mysql calcular idade
SQL
4 votes107 views1 answer
Oracle select first 10 rows
SQL
0 vote116 views1 answer
Mysql date only no time
SQL
0 vote119 views1 answer
How to print sql query
SQL
0 vote147 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote128 views1 answer
How to change mysql port in xampp
SQL