密码修改

原理更新 mysql.user 表的密码字段

5.1 密码字段password

5.7 密码字段authentication_string

update user set authentication_string=password('123') where user='root';

刷新权限

flush privileges;

任何IP访问

grant all privileges on *.* to 'root'@'%' identified by 'rootroot' with grant option;