转自:http://blog.chinaunix.net/uid-20718384-id-3322167.html
mysql root用户密码忘记或者是权限不对。
1. 先停止mysql
- sudo service mysql stop
- sudo mysqld_safe --user=mysql --skip-grant-tables --skip-networking
- mysql -u root mysql
- update user set password=PASSWORD('newpassword') where user='root';
- select * from user where user='root';
- update user set Grant_priv='Y' where user='root';
- kill -9 mysqld_safe_pid
- pkill mysql
- service mysql start