mysql数据库允许远程访问

1、确保iptable放开对应的端口限制

sudo iptables -A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
        sudo iptables -L

iptables配置文件路径/etc/sysconfig/iptables

限制访问的端口IP设置样例：-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -s 11.241.37.91 -j ACCEPT，这样就只允许11.241.37.91访问了

修改问配置文件后记得重启服务，不是/etc/inid.d/iptables save哦，是service iptables restart

2、新增记录

insert into user (Host, User, Password) VALUES('%', 'root', PASSWORD('123456'));

3、授权

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

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

http://www.cnblogs.com/cnblogsfans/archive/2009/09/21/1570942.html

4、刷新

FLUSH PRIVILEGES