MySQL caching_sha2_password

Hi

I am connect to MySQL database and I am getting this exception

Thanks for help

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'host': '78.135.79.26',
        'database': 'otomabakdb',
        'user': 'otomabakus',
        'password': 'password1',
        'port': 3306,
    }
}

Traceback (most recent call last):

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection

    self.connect()

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 194, in connect

    self.connection = self.get_new_connection(conn_params)

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\mysql\base.py", line 236, in get_new_connection

    return Database.connect(**conn_params)

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\MySQLdb\__init__.py", line 86, in Connect

    return Connection(*args, **kwargs)

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\MySQLdb\connections.py", line 204, in __init__

    super(Connection, self).__init__(*args, **kwargs2)

_mysql_exceptions.OperationalError: (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found.\r\n")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):

  File "manage.py", line 15, in <module>

    execute_from_command_line(sys.argv)

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\management\__init__.py", line 371, in execute_from_command_line

    utility.execute()

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\management\__init__.py", line 365, in execute

    self.fetch_command(subcommand).run_from_argv(self.argv)

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\management\base.py", line 288, in run_from_argv

    self.execute(*args, **cmd_options)

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\management\base.py", line 332, in execute

    self.check()

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\management\base.py", line 364, in check

    include_deployment_checks=include_deployment_checks,

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\management\commands\migrate.py", line 57, in _run_checks

    issues = run_checks(tags=[Tags.database])

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\checks\registry.py", line 73, in run_checks

    new_errors = check(app_configs=app_configs)

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\checks\database.py", line 10, in check_database_backends

    issues.extend(conn.validation.check(**kwargs))

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\mysql\validation.py", line 9, in check

    issues.extend(self._check_sql_mode(**kwargs))

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\mysql\validation.py", line 13, in _check_sql_mode

    with self.connection.cursor() as cursor:

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor

    return self._cursor()

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor

    self.ensure_connection()

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection

    self.connect()

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\utils.py", line 89, in __exit__

    raise dj_exc_value.with_traceback(traceback) from exc_value

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection

    self.connect()

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 194, in connect

    self.connection = self.get_new_connection(conn_params)

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\mysql\base.py", line 236, in get_new_connection

    return Database.connect(**conn_params)

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\MySQLdb\__init__.py", line 86, in Connect

    return Connection(*args, **kwargs)

  File "C:\Users\Kadir\AppData\Local\Programs\Python\Python36-32\lib\site-packages\MySQLdb\connections.py", line 204, in __init__

    super(Connection, self).__init__(*args, **kwargs2)

django.db.utils.OperationalError: (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found.\r\n")

--
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+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@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/ef32b5c2-6817-408a-8fcf-090fbc89ddd7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.