解决:
1.先关闭mysql服务
# service mysql stop
2.用安全模式进入:
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
后台运行
3.然后直接免密进入mysql:
# mysql -uroot
4.更改mysql密码:
mysql> UPDATE mysql.user SET PASSWORD=PASSWORD('root') where USER='root';
这里用户名密码均为root
5.mysql> FLUSH PRIVILEGES;
6.退出mysql,重启mysql服务:
# service mysql restart;
7.用密码进入mysql :
# mysql -uroot -p
8.顺便修改一下权限:
mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'root' with grant option;