MySQL error in Python - cannot connect to MySQL server

Question

I have a question:

My input:

import mysql.connector
import mysql.connector

mydb = mysql.connector.connect(
    host = 'localhost',
    user = 'root',
    passwd = 'ananthjeahinowiamshowingmypasswordwitchisnotmypassword'
)
print(mydb)

And this is the output:

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

Also, if that's the real password, might consider using `'*****'` for posting on SO. It may not matter in this case, but good practice in general. — bart cubrich, Apr 10 '19 at 18:03

score 0 · Accepted Answer · edited Jan 02 '22 at 21:37

0

Install the Python MySQL driver:

Official document

Similar Stack Overflow question

Just make sure to install the correct connector based on your operating system, MySQL version and the Python version you use:

pip install mysql-connector-python

edited Jan 02 '22 at 21:37

Peter Mortensen

30,738
21
105
131

answered Apr 10 '19 at 17:52

devesh

618
6
26

MySQL error in Python - cannot connect to MySQL server

1 Answers1