通过命令修改,具体如下:
1.停止运行MySQL服务
/etc/init.d/mysql stop
2.跳过验证并启动MySQL
/usr/local/mysql/bin/mysqld_safe –skip-grant-tables >/dev/null 2>&1 &
然后:
mysql mysql -uroot //登陆 mysql> UPDATE user SET Password=PASSWORD(‘new password’) where USER=’root’; mysql> FLUSH PRIVILEGES; mysql> quit
最后重新启动mysql
/etc/init.d/mysql start