1>修改MySQL的登录设置:
- # vi /etc/my.cnf
在[MySQLd]的段中加上一句:skip-grant-tables
例如:
Java代码
- [MySQLd]
- datadir=/var/lib/MySQL
- socket=/var/lib/MySQL/MySQL.sock
- skip-name-resolve
- skip-grant-tables
- [MySQLd]
- datadir=/var/lib/MySQL
- socket=/var/lib/MySQL/MySQL.sock
- skip-name-resolve
- skip-grant-tables
保存并且退出vi。
2>重新启动MySQLd
- # /etc/init.d/MySQLd restart
- Stopping MySQL: [ OK ]
- Starting MySQL: [ OK ]
3>登录并修改MySQLroot密码
Xml代码
- # /usr/bin/MySQL
- .
- MySQL> USE MySQL ;
- MySQL> UPDATE user SET Password = password('new-password') WHERE User = 'root' ;
- MySQL> flush privileges ;
- MySQL> quit
- # /usr/bin/MySQL
- .
- MySQL> USE MySQL ;
- MySQL> UPDATE user SET Password = password('new-password') WHERE User = 'root' ;
- MySQL> flush privileges ;
- MySQL> quit
4>将MySQL的登录设置修改回来
- # vi /etc/my.cnf
将刚才在[MySQLd]的段中加上的skip-grant-tables删除
保存并且退出vi。
5>重新启动MySQLd
- # /etc/init.d/MySQLd restart
- Stopping MySQL: [ OK ]
- Starting MySQL: [ OK ]