1、mysql server安装完毕,远程登录不上 1130错误
mysql -u用户名 -p密码 mysql>use mysql; mysql>update user set host = '%' where user = 'root'; mysql>flush privileges;
2、navicat 登录 caching_sha2_password can not be loaded
mysql>alter user 'root'@'localhost' identified with mysql_native_password by 'password'; mysql>flush privileges;
标签:privileges,MySql,flush,user,mysql,password,安装,调试 From: https://www.cnblogs.com/GreenLeaves/p/16646424.html