How to change the authentication configuration of mysql connector to python?

Question

I was trying to connect MySQL with python via the following code.

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="qwerty",
  auth_plugin="mysql_native_password"
)

print(mydb)

It gave me the following error:-

mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

My connector version is:-

C:\Users\samar>pip install mysql-connector-python
Requirement already satisfied: mysql-connector-python in c:\users\samar\anaconda3\lib\site-packages (8.0.21)

Kiran Kumar · Accepted Answer · 2020-11-25 12:50:11Z

1

import pymysql

host="localhost"
user="root"
passwd="qwerty"
db="<give db name"

def dbConnectivity(host,user, passwd, db):
    try:
        db = pymysql.connect(host=host,
                             user=user,
                             passwd=passwd,
                             db=db)
        cursor = db.cursor()
        print("Great !!! Connected to MySQL Db")
        return cursor
    except pymysql.Error as e:
        print("Sorry !! The error in connecting is:" + str(e))
        return str(e)

dbConnectivity(host,user,passwd,db)

answered Nov 25, 2020 at 12:50

Kiran Kumar

111 bronze badge

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

1 Comment

GuiTaek Over a year ago

This doesn't answer the question, he asks for connecting to a legacy database, for which his solution is nearer than this solution

Collectives™ on Stack Overflow

How to change the authentication configuration of mysql connector to python?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related