您可以通过以下五个简单步骤来恢复MysqL数据库服务器密码。
:停止MysqL服务器进程。
:使用–skip-grant-tables选项启动MysqL(MysqLd)服务器/守护进程,以使其不提示输入密码。
:停止MysqL服务
# /etc/init.d/MysqL stop
输出:
Stopping MysqL database server: MysqLd.
:启动没有密码的MysqL服务器:
# MysqLd_safe --skip-grant-tables &
输出:
[1] 5988
Starting MysqLd daemon with databases from /var/lib/MysqL
MysqLd_safe[6025]: started
# MysqL -u root
输出:
Welcome to the MysqL monitor. Commands end with ; or \g.
Your MysqL connection id is 1 to server version: 4.1.15-Debian_1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
MysqL>
MysqL> use MysqL;
MysqL> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
MysqL> flush privileges;
MysqL> quit
:停止MysqL服务器:
# /etc/init.d/MysqL stop
输出:
Stopping MysqL database server: MysqLd
STOPPING server from pid file /var/run/MysqLd/MysqLd.pid
MysqLd_safe[6186]: ended
[1]+ Done MysqLd_safe --skip-grant-tables
:启动MysqL服务器并进行测试
# /etc/init.d/MysqL start
# MysqL
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
# MysqL -u root -p
资料来源:http ://www.cyberciti.biz/tips/recover-mysql-root- password.html