1、停用MySQL服务:# /etc/rc.d/init.d/MysqLd stop
2、输入命令:# MysqLd_safe --user=MysqL --skip-grant-tables --skip-networking &
3、登入数据库:# MysqL -u root MysqL
4、MysqL> use MysqL;结果如下:
Database changed
5、MysqL> UPDATE user SET Password=PASSWORD('newpassword')where USER='newuser';
结果如下:
Query OK,3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0
MysqL> FLUSH PRIVILEGES;
ottom:0px; padding-top:0px; padding-bottom:0px; color:rgb(85,0 rows affected (0.00 sec)
MysqL> quit
# /etc/init.d/MysqLd restart
# MysqL -unewuser–p
Enter password:newpassword
MysqL><登录成功>