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': 'root@localhost',

        'PASSWORD': 'prodot123',

        'HOST':'127.0.0.1',

        'PORT':'3306'

    }

}

Any help would be appreciated!

Sender notified by Mailtrack 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!

Sender notified by Mailtrack 11/16/18, 12:56:15 AM

On Fri, Nov 16, 2018 at 12:19 AM Jason <jjohn...@gmail.com> wrote:

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 email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
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.
For more options, visit https://groups.google.com/d/optout.

[Mamadou Harouna Diallo]

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

--

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 email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
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.