navicat连接mysql相关问题

1、连接服务器: mysql -u root -p
2、进入mysql数据库：use mysql;
3、查看user表中的数据：select Host, User from user;
4、修改user表中的Host:update user set Host=’%’ where User=’root’;
5、最后刷新一下：flush privileges;

1、更改加密方式：ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
2、更改密码：ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;
3、刷新：FLUSH PRIVILEGES;
4、如果报错 ERROR 1396 (HY000): Operation ALTER USER failed for ‘root’@’localhost’ ：则是远程访问权限不正确
先选择数据库，查看一下再更改：确定是修改’root’@’% 还是修改’root’@’localhost’