背景: 用nodejs搭了套后端服务,前后端打通之后,配置数据库,发现数据库配置上之后服务起不来了,报错和解决方案如下
报错:
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决方案:
// 进入mysql环境
mysql -u root -p
// 执行命令
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '12345678';