MySQL忘记root密码以及远程无法连接的解决方法

目录

• 1. mysql忘记root密码
• 2. 解决远程无法连接mysql

 /etc/init.d/mysql stop

 mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

mysql -u root mysql

mysql> UPDATE user SET Password=PASSWORD(‘abc123') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

 /etc/init.d/mysql restart

mysql -uroot –p

grant all privileges on *.* to root@192.168.191.168 identified by 'abc123';