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

0 votes

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?

Jul 15, 2020 in Python by akhtar
• 38,170 points
7,369 views

1 answer to this question.

0 votes

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')
answered Jul 15, 2020 by MD
• 95,180 points
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.

Related Questions In Python

0 votes
1 answer
0 votes
1 answer

Error is '<' not supported between instances of str and int

your dis is obviously not 1.13, it's ...READ MORE

answered Nov 15, 2020 in Python by Gitika
• 65,870 points
2,653 views
0 votes
1 answer

ImportError: Import by filename is not supported

Instead of doing a import like __import__ you can ...READ MORE

answered Nov 26, 2020 in Python by Gitika
• 65,870 points
375 views
0 votes
1 answer

Raw_input method is not working in python3. How to use it?

raw_input is not supported anymore in python3. ...READ MORE

answered May 4, 2018 in Python by aayushi
• 750 points
1,704 views
0 votes
1 answer

Error:Python3.4 can't install mysql-python

Hello @kartik, You can resolved this by the ...READ MORE

answered Jun 24, 2020 in Python by Niroj
• 82,720 points
633 views
0 votes
1 answer

How to create MySql database using Python?

Hi@akhtar, You need to use MySQL connector in ...READ MORE

answered Jul 15, 2020 in Python by MD
• 95,180 points
144 views
0 votes
1 answer

How to insert a date into MySQL using Python?

Hi@akhtar, You can use the DateTime module to insert a date into ...READ MORE

answered Jul 15, 2020 in Python by MD
• 95,180 points
1,794 views
0 votes
1 answer

ProgrammingError: not all arguments converted during string formatting

Sorted!!!! just found the solution, 1 - apparently ...READ MORE

answered Sep 10, 2018 in Python by Priyaj
• 58,120 points
12,514 views
0 votes
2 answers

NameError: name 'raw_input' is not defined

Hi, There may a problem with your python ...READ MORE

answered Jun 25, 2020 in Python by MD
• 95,180 points
25,487 views