MySQL caching_sha2_password

[Ansh Srivastava]

Hi experts, I am tryin' to connect to MySQL database and the following
error flashed!

return Database.connect(**conn_params)
File
"C:\Users\ansh\AppData\Local\Programs\Python\Python36\lib\site-packages\M
ySQLdb\__init__.py", line 86, in Connect
return Connection(*args, **kwargs)
File
"C:\Users\ansh\AppData\Local\Programs\Python\Python36\lib\site-packages\M
ySQLdb\connections.py", line 204, in __init__
super(Connection, self).__init__(*args, **kwargs2)
django.db.utils.OperationalError: (2059, "Authentication plugin
'caching_sha2_pa
ssword' cannot be loaded: The specified module could not be found.\r\n")

In the settings.py, I got following:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'marvellous' ,
'USER': '***@localhost',
'PASSWORD': 'prodot123',
'HOST':'127.0.0.1',
'PORT':'3306'
}
}

Any help would be appreciated!

[image: Mailtrack]
<https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&>
Sender
notified by
Mailtrack
<https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&>
11/15/18,
11:47:53 PM

[Jason]

did you try googling the error? a simple google query returned a number of
possible avenues of investigation

[Ansh Srivastava]

Yes @Jason
I am swamped with all those googling but nothin' found there!

[image: Mailtrack]
<https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&>
Sender
notified by
Mailtrack
<https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&>
11/16/18,
12:56:15 AM

Post by Jason
did you try googling the error? a simple google query returned a number
of possible avenues of investigation

--

You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/85aef7a0-7b9f-4262-838e-51392593eea9%40googlegroups.com
<https://groups.google.com/d/msgid/django-users/85aef7a0-7b9f-4262-838e-51392593eea9%40googlegroups.com?utm_medium=email&utm_source=footer>
.
For more options, visit https://groups.google.com/d/optout.

...

[Mamadou Harouna Diallo]

Are install pymysql ? If aren't you need install it

Post by Ansh Srivastava
Hi experts, I am tryin' to connect to MySQL database and the following
error flashed!
return Database.connect(**conn_params)
File
"C:\Users\ansh\AppData\Local\Programs\Python\Python36\lib\site-packages\M
ySQLdb\__init__.py", line 86, in Connect
return Connection(*args, **kwargs)
File
"C:\Users\ansh\AppData\Local\Programs\Python\Python36\lib\site-packages\M
ySQLdb\connections.py", line 204, in __init__
super(Connection, self).__init__(*args, **kwargs2)
django.db.utils.OperationalError: (2059, "Authentication plugin
'caching_sha2_pa
ssword' cannot be loaded: The specified module could not be found.\r\n")
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'marvellous' ,
'PASSWORD': 'prodot123',
'HOST':'127.0.0.1',
'PORT':'3306'
}
}
Any help would be appreciated!
[image: Mailtrack]
<https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&> Sender
notified by
Mailtrack
<https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&> 11/15/18,
11:47:53 PM
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAHMQ531U6DEiDpri8dqdR7N1SJmXAvpZ%3DMrNyXQ1OFcCB7FC3g%40mail.gmail.com
<https://groups.google.com/d/msgid/django-users/CAHMQ531U6DEiDpri8dqdR7N1SJmXAvpZ%3DMrNyXQ1OFcCB7FC3g%40mail.gmail.com?utm_medium=email&utm_source=footer>
.
For more options, visit https://groups.google.com/d/optout.

...