mysql允许外网访问以及修改mysql账号密码实操方法

mysql -u root -pvmwaremysql>use mysql;
mysql>update user set host = '%' where user ='root';
mysql>select host, user from user;
mysql>flush privileges;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin123' WITH GRANT OPTION;
flush privileges;

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.104'  IDENTIFIED BY 'admin123' WITH GRANT OPTION;
flush privileges;

use mysql;

update user set authentication_string=password('新密码') where user='root' and Host='localhost';

flush privileges;