mysql reports Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Cause: An error is reported due to the mysql8.0 encryption method.

Solution:

execute instruction

mysql -u root -p

123456

use mysql;

alter user ‘root’@’localhost’ identified with mysql_native_password by ‘123456’;

flush privileges;

Note: 123456 is my own password to connect to the database

Similar Posts:

• [Solved] Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by serv
• Error in connecting to MySQL via Navicat on MAC
• [Solved] Node Connect MYSQL Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
• MySQL Connect Error: Authentication plugin ‘caching_sha2_password’ cannot be loaded
• [Solved] MYSQL Error: this authentication plugin is not supported
• [Solved] MYSQL Error: django.db.utils.OperationalError: (1045:Access denied for user ‘root’@’localhost’ (using password: NO)
• [Solved] ER_NOT_SUPPORTED_AUTH_Mode node connection database error
• MYSQL 8.0 Login Error: caching_sha2_password [How to Solve]
• ERROR 1044 (42000): Access denied for user ‘root’@’localhost’
• [Solved] MYSQL8.0 Error: the user specified as a definer (‘root’@’%’) does not exist