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~