How to Solve Client does not support authentication protocol requested by server; Consider upgrading MySQL

Today, the server deployed node.js + MYSQL, and the calling interface reported an error er_ NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

After checking the information, I changed two places

1. Server security group policy is configured and 3306 port is added

2. I modify the MySQL encryption rules to normal mode, and the default is strict encryption mode

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的数据库密码';

The operation steps are as follows: then restart node.js to test

It’s done~

 

Similar Posts: