ndoe 连接mysql报错

mysql版本:8.0.20

node 连接mysq报错信息:Client does not support authentication protocol requested by server; consider upgrading MySQL client,

 

 

 解决方法:

mac终端进入mysql,打开终端输入:/usr/local/MySQL/bin/mysql -u root -p

输入:ALTER USER 'root'@'localhost'IDENTIFIED WITH mysql_native_password BY 'your password';(注意:分号要带上)

在输入:FLUSH PRIVILEGES;(注意:分号要带上)

 

posted @ 2020-05-28 10:19  柠檬可乐  阅读(138)  评论(0编辑  收藏  举报