/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

11 votes223 views5 answers
How to install sqlite3 python
SQL
2 votes221 views3 answers
Sql function
SQL
0 vote220 views1 answer
Ms sql filter all sympbol
SQL
0 vote196 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote248 views2 answers
Start mysql server using docker
SQL
0 vote209 views1 answer
Query to insert image
SQL
12 votes255 views4 answers
How to drop all tables in postgresql
SQL
1 vote223 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
4 votes221 views2 answers
Tsql utf to local time
SQL
0 vote236 views1 answer
Oracle webcenter content search enginer
SQL