mysql connector errors NotSupportedError Authentication plugin caching sha2 password is not supported

Question

Hi Guys,

I am trying to connect with MySQL, but I am facing the below error which I am not able to understand.

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

How can I solve this error?

Answer 1

Hi@akhtar,

According to SQL documentation for python library. you need to specify the auth plugin as follows in your code as given below.

conn = mysql.connector.connect(user='root', password='password', host='127.0.0.1',port=5000,database='test',
auth_plugin='mysql_native_password')

Get a further understanding from the SQL Certification Course

Comments

Try installing:

pip mysql-connector-python

hope it works

---

Yeah., pip install mysql-connector-python worked!!!

---

yes it worked for me also

---

I mentioned auth_plugin but still i am getting the same error

---

Hi@sanket,

Did you try the above solution? If it is not working then reinstall it and try once.