Centos 下忘记Mysql数据库root密码解决方法
1.停止mysql服务
/etc/init.d/mysql stop
2.以skip-grant-tables参数启动mysql
/usr/local/mysql/bin/mysqld_safe –skip-grant-tables &
3.以空密码方式登录mysql
mysql -u root
4.重置root账号密码
update mysql.user set password=PASSWORD(‘newpassword’) where User=’root’;
5.刷新权限表
flush privileges;
6.退出mysq并重启
exit
/etc/init.d/mysql restart