Client does not support authentication pr
2021-05-02 小于 1 分钟
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication pr
错误原因;
- 原因8.0mysql引入了caching_sha2_password模块作为默认身份验证插件,nodejs还没有跟进
解决;
- ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '自己的密码';
启动mysql;
service mysqld start;
1关闭mysql
service mysqld stop
1查看Mysql的运行状态;
service mysqld status;
1