MySQL caching_sha2

Kadir Guloglu

unread,

May 18, 2018, 6:03:52 PM5/18/18

to Django users

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")

Fidel Leon

unread,

May 19, 2018, 7:49:19 AM5/19/18

to django...@googlegroups.com

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

fi...@flm.cat

Phone: +34 622 26 44 92

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

--
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/ef32b5c2-6817-408a-8fcf-090fbc89ddd7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Gagan Kalia

unread,

Aug 24, 2018, 4:16:14 AM8/24/18

to Django users

For me below solved the issue. The oracle MYSql connector was refusing to install. The installer was just disappearing and doing nothing.

https://github.com/passbolt/passbolt_docker/issues/103

Command that worked:

ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';

Reply all

Reply to author

Forward

MySQL caching_sha2_password

Kadir Guloglu

Fidel Leon

Gagan Kalia