error authenaticating sql database from python

Question

I am trying to run this code:

from flask_sqlalchemy import SQLAlchemy

import mysql.connector
import csv
import pandas as pd

mydb = mysql.connector.connect(
  host="127.0.0.1",
  user="root",
  passwd="abc123",
  database="db"

)

But I am receiving this error:

    Traceback (most recent call last):
      File "C:\Users\user123\Desktop\SQLtest\setup.py", line 10, in <module>
        passwd="abc123",

    .
    .
    .
 "Authentication plugin '{0}' is not supported".format(plugin_name))
mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

Any help would be appreciated.

Zeid Al-Rashwani · Accepted Answer · 2019-07-20 00:57:30Z

1

This error appears because MySQL 8 uses caching_sha2_password as the default authentication plugin rather than mysql_native_password.

To solve this issue, try adding auth_plugin='mysql_native_password' to your connection parameters - to make your connection uses the native authentication plugin - as below:

mydb = mysql.connector.connect(
  host="127.0.0.1",
  user="root",
  passwd="abc123",
  database="db",
  auth_plugin="mysql_native_password"
)

answered Jul 20, 2019 at 0:57

Zeid Al-Rashwani

5755 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user11015000 Over a year ago

I tried that, but still getting this error:

"Authentication plugin '{0}' is not supported".format(plugin_name)) mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

Zeid Al-Rashwani Over a year ago

Can you try using mysql-connector-python instead of mysql-connector? install it via pip, e.g: pip install mysql-connector-python

user11015000 Over a year ago

I created a new database and connected to it and now it works? Thanks for your help anyway

Collectives™ on Stack Overflow

error authenaticating sql database from python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related