mysql忘记密码

修改/etc/my.cnf，加入:
skip-grant-tables

重启mysql
 update mysql.user set password=password('111111') where user='root';

删除/etc/my.cnf,重启mysql