Why do I get this error while running django project even after adding mysql to settings?

Question

When I try to run the django project, I get this error:

django.db.utils.OperationalError: (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory")

scriptmonster · Accepted Answer · 2019-04-11 09:22:33Z

3

It's seems like a database error. Your database is set to use caching_sha2_password as an authentication plugin. You need to change it from your mysql config.

In your mysql configuration file, you may want to change default_authentication_plugin parameter:

[mysqld]

default_authentication_plugin=mysql_native_password

You need to restart mysql server to make this change active.

Also you may change it by user with the following sql statement:

ALTER USER 'user'@'host' IDENTIFIED WITH mysql_native_password BY 'password';

If you do not depend on mysql you can change database engine to sqlite and run the project. If there is no coding error, it should run smoothly. After solving mysql issue you can switch back to mysql backend.

edited Apr 11, 2019 at 9:22

answered Apr 11, 2019 at 9:17

scriptmonster

2,76921 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why do I get this error while running django project even after adding mysql to settings?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related