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?

Comments

pip install mysql-connector-python its also work for me ... thank you

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.

---

Thank u so much Ramya. The solution is the best

---

Wonderfull, my friend. For me it was the solution.

Congrats smart guy.

Tks

---

where should we use it - on command prompt or powershell

---

Thank You dude, it worked

I installed (mysql-connector-python) by using:

pip mysql-connector-python

then i executed my code again and it worked! 

Many Thanks.

---

Yes!!pip install mysql-connector-python worked thank you

---

InterfaceError: 2003: Can't connect to MySQL server on '127.0.0.1:5000' (10061 No connection could be made because the target machine actively refused it)

Answer 2

I had the same problem and passing auth_plugin='mysql_native_password' did not work, because I accidentally installed mysql-connector instead of mysql-connector-python (via pip3). Just leaving this here in case it helps someone.