/Python/Mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

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

100 votes309 views5 answers
Python -m pip install --upgrade pip
Python
0 vote374 views1 answer
Flask extends two base.html
Python Flask
0 vote328 views1 answer
How to find the closest value in column python
Python
0 vote281 views1 answer
Python del var if exists
Python
3 votes339 views1 answer
Pandas plotly
Python
1 vote304 views2 answers
How to define the name of your tkinter window
Python
26 votes294 views2 answers
How to build an auto emailer in python
Python
2 votes290 views2 answers
Last element python
Python
0 vote311 views1 answer
Remove hh:mm:ss from pandas dataframe column
Python
0 vote295 views1 answer
The module in NAME could not be imported: django.contrib.user_auth.password_validation.UserAttributeSimilarityValidator. Check your AUTH_PASSWORD_VALI
Python