记录一下mysql连接提示ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication

111 阅读1分钟

使用node连接mysql

# [ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client](https://www.cnblogs.com/leileig/p/16352093.html "发布于 2022-06-07 15:46")

大概问题就是 登录数据库的客户端跟mysql8.0不兼容了,mysql8.0密码认证采用了新的密码格式 解决方式: 登录mysql

ALTER USER `root@localhost` IDENTIFIED WITH mysql_native_password BY '123456';

FLUSH PRIVILEGES;

即可解决