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 in Python by akhtar
• 17,690 points
113 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 by MD
• 40,740 points

Related Questions In Python

0 votes
1 answer
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
956 views
0 votes
1 answer

'python' is not recognized as an internal or external command

I have met same issue when I ...READ MORE

answered Aug 24, 2018 in Python by Priyaj
• 57,550 points
233 views
0 votes
1 answer

Python `if x is not None` or `if not x is None`?

There's no performance difference, as they compile ...READ MORE

answered Sep 3, 2018 in Python by Priyaj
• 57,550 points
721 views
0 votes
1 answer
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 in Python by MD
• 40,740 points
19 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 in Python by MD
• 40,740 points
29 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
• 57,550 points
8,594 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 in Python by MD
• 40,740 points
14,523 views