Re: MySQL caching_sha2_password

You my want to check: https://stackoverflow.com/questions/50416391/caching-sha2-password-plugin-failing-on-windows

Basically, you'd need to install Oracle MySQL's official Python connector.

Besides, you have posted a server database configuration, including an IP and a port that are 100% reachable from the Internet:

MySQL Error 1045 (28000): Access denied for user 'root'@'92.187.87.65' (using password: YES)

Not the best idea...

Fidel Leon

fidel@flm.cat

Phone: +34 622 26 44 92

GPG: 2585 30C2 E3C7 7151 0864  946B 7423 F94B 5753 5FC7

El 19 de mayo de 2018 a las 0:04:32, Kadir Guloglu (kadirguloglu1@gmail.com) escribió:

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.