下载navicat时:路径:
密码解析机制更改
ALTER USER 'root'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';
FLUSH PRIVILEGES;
SELECT user FROM mysql.user;
update user set host = '%' where user = 'root';
select host, user from user;
SELECT user FROM mysql.user;
use mysql
update user set host = '%' where user = 'root';
flush privileges;