why geting error while mysql to python connection establishment?

Question

When I am connecting db in Python I am getting error:

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

Code:

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  passwd="prakash17"
)
print(mydb)

anonimac · Accepted Answer · 2019-04-04 12:54:20Z

1

Solution would be to install mysql-connector-python instead of mysql-connector:

pip install mysql-connector-python

answered Apr 4, 2019 at 12:54

anonimac

262 bronze badges

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

Comments

Ferdous Hussain · Accepted Answer · 2019-04-04 16:16:29Z

0

I think the issue is you have misspelled password. Try this password = 'prakash17'

If that doesn't work then try password = ' '

Also make sure your Xampp is runny apache and mysql. Good luck!

answered Apr 4, 2019 at 16:16

Ferdous Hussain

736 bronze badges