参考:
linux下安装Mysql
更改root用户密码
样例:
update mysql.user set password=password(‘root’) where user=‘root’;
flush privileges;
更改root连接限制
ERROR 1130: Host .***.***. is not allowed to connect to this MySQL server
样例:
MySQL> update user set host=’%’ where user = ‘root’;