mysql忘记密码/修改密码

关闭mysql

service mysql stop

无密码登录msyql

mysqld_safe –skip-grant-tables &

root连接mysql

mysql -u root

修改密码

use mysql

update user set password=PASSWORD(‘admin’) where User=’root’;

刷新权限

flush privileges;

重启mysql

service msyql restart