Linux mysql 忘记密码

//跳过权限检测

mysqld --skip-grant-tables

查看是否有user表

show tables like "%user%";

更改权限

mysql >update user set Host='192.168.%.%‘ where Host='192.168.140.%';

更新权限

flush priviledges;