Error Messages:
django.db.utils.OperationalError: (1045:Access denied for user ‘root’@’localhost’ (using password: NO)
Solution:
Run the following in mysql console, to change the password encryption method to the old version in Mysql(it is changed to use cha2 in Mysql 8.0)
Run the following in mysql console, to change the password encryption method to the old version in Mysql(it is changed to use cha2 in Mysql 8.0)
mysql -u root -p
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newpassword';
FLUSH PRIVILEGES;
Reference:
Similar Posts:
- MySQL Connect Error: Authentication plugin ‘caching_sha2_password’ cannot be loaded
- [Solved] MYSQL Error: this authentication plugin is not supported
- Error in connecting to MySQL via Navicat on MAC
- ERROR 1044 (42000): Access denied for user ‘root’@’localhost’
- [Solved] Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by serv
- [Solved] Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by serv
- [Solved] MYSQL8.0 Error: the user specified as a definer (‘root’@’%’) does not exist
- MYSQL 8.0 Login Error: caching_sha2_password [How to Solve]
- [Solved] Node Connect MYSQL Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
- [Solved] SQLyog Connect MYSQL Error: 2058 plugin caching_sha2_password could not be loaded