停止mysql

service mysqld stop

启动mysql

mysqld --user=root --skip-grant-tables &

更新密码

UPDATE mysql.user SET authentication_string=PASSWORD('123456') where USER='root'; ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; SET PASSWORD FOR root=PASSWORD('123456');

flush privileges; // 刷新设置立即生效

exit // 退出,或者使用 quit 命令

重启服务

service mysqld restart