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'; On Saturday, 19 May 2018 17:19:19 UTC+5:30, Fidel Leon wrote: > > 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 <javascript:> > 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 (kadirg...@gmail.com > <javascript:>) 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...@googlegroups.com <javascript:>. > To post to this group, send email to django...@googlegroups.com > <javascript:>. > 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 > > <https://groups.google.com/d/msgid/django-users/ef32b5c2-6817-408a-8fcf-090fbc89ddd7%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > > -- 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+unsubscr...@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/0aa52fae-debb-4a05-8dfe-e0239ec70e9f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
