mysql8.0以上使用navicat连接不上

root登录修改指定用户密码

ALTER USER 'eduser'@'%' IDENTIFIED WITH mysql_native_password BY '1SJSXPS8';

ALTER USER 'eduser'@'%' IDENTIFIED BY '1SJSXPS8' PASSWORD EXPIRE NEVER;

FLUSH PRIVILEGES;

posted @ 2020-09-15 15:25  景恩  阅读(745)  评论(0编辑  收藏  举报