/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

5 votes329 views4 answers
Rollback to in sql
SQL
9 votes354 views3 answers
Postgres make sql dump
SQL
0 vote323 views1 answer
Oracle string substitution
SQL
0 vote331 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote375 views1 answer
Virtuoso sql query tutorial
SQL
0 vote331 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
3 votes319 views1 answer
Sql server check version
SQL
18 votes327 views6 answers
Laravel form validation
SQL
1 vote332 views1 answer
Error code 1292 mysql workbench
SQL
-1 vote330 views1 answer
Condition in orderby mysql
SQL