cd /
/etc/init.d/mysqld stop
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
新建一个会话窗口.输入以下命令
mysql -u root mysql
UPDATE user SET Password=PASSWORD('950713') where USER='root';
FLUSH PRIVILEGES;
quit
重启mysql:命令如下
/etc/init.d/mysqld restart
新建会话窗口,使用root用户重新登录mysql,命令如下,括号内的,括号不算在内
mysql -uroot -p950713
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '950713' WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit
我又重启mysql了,不知道多余不
/etc/init.d/mysqld restart
③关闭防火墙
关闭防火墙,立即生效
chkconfig iptables off
service iptables stop
出现3个ok,表示成功