/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 vote297 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote331 views1 answer
Php mysqli install
SQL
21 votes324 views1 answer
Cheatsheet for sql
SQL
1 vote313 views3 answers
How to truncate foreign key constraint table
SQL
0 vote322 views1 answer
Postgres drop type
SQL
4 votes320 views2 answers
Mysql alter table set column unique
SQL
0 vote350 views1 answer
How to change mysql root password in windows 10
SQL
0 vote322 views1 answer
Sql period overlap
SQL
0 vote341 views1 answer
Get clob size oracle
SQL
0 vote298 views1 answer
Including parameters in OPENQUERY
SQL