Mysql 设置远程连接

授权的方式允许任何主机访问mysql服务器：

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

 

限定ip访问：

mysql>GRANT ALL PRIVILEGES ON *.* TO 'jack'@’10.10.50.127’ IDENTIFIED BY 'password' WITH GRANT OPTION;

 但其实限定ip也可以通过firewalld。