linux 远程连接数据库

mysql>GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3'IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 
mysql>FLUSH PRIVILEGES
#关闭防火墙
#通过systemctl status firewalld查看firewalld状态 
 #FirewallD is not running systemctl unmask firewalld 
 systemctl start firewalld 
 #再次通过systemctl status firewalld查看firewalld状态
 ，显示running即已开启了。 
 #再次执行执行firewall-cmd --permanent --zone=public --add-port=3306/tcp，提示success，表示设置成功，这样就可以继续后面的设置了。 
 firewall-cmd --reload 
 systemctl stop firewalld.service #关闭防火墙
 
 改表法
 #mysql -u root -p Enter password: 
 mysql>update user set host = '%' where user = 'root'; 
 mysql>select host, user from user;