CentOS服务器mysql忘记root密码恢复,centos密码恢复
CentOS服务器mysql忘记root密码恢复,centos密码恢复
mysql的root忘记,现无法操作数据库
停止mysql服务servicemysqlstop
或者是ps-ef|grepmysql|xargskill-9
然后使用如下的参数启动mysql,--skip-grant-tables会跳过mysql的授权
shell#/usr/bin/mysqld_safe--skip-grant-tables&
mysql-p回车,进入不需要密码
mysql>
mysql>updatemysql.usersetPassword=password('itnihao')whereUser='root';
QueryOK,4rowsaffected(0.00sec)
Rowsmatched:4Changed:4Warnings:0
mysql>flushprivileges;
QueryOK,0rowsaffected(0.00sec)
重启mysql,
servicemysqlstop或者是ps-ef|grepmysql|xargskill-9
mysql-p
然后输入密码,至此,mysql密码已经修改完毕
评论暂时关闭