缺省情况下MySQL只能本地进行连接，为了能远程进行访问，可以使用以下设置方法：
一、授权
GRANT ALL PRIVILEGES ON *.* TO 'username'@'183.228.187.%' IDENTIFIED BY '123';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION ;
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
更详细的权限请参见：http://www.newxin99.com/bbs/forum.php?mod=viewthread&tid=7
设置之后，需要重启MySQL或使用下面的语句来使设置生效
FLUSH PRIVILEGES;
二、查看授权情况
USE mysql;
SELECT * FROM USER;
三、收回权限
与设置权限相似，只是将TO改为FROM
REVOKE ALL PRIVILEGES ON *.* FROM 'username'@'183.228.187.99'
一、授权
GRANT ALL PRIVILEGES ON *.* TO 'username'@'183.228.187.%' IDENTIFIED BY '123';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION ;
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
更详细的权限请参见：http://www.newxin99.com/bbs/forum.php?mod=viewthread&tid=7
设置之后，需要重启MySQL或使用下面的语句来使设置生效
FLUSH PRIVILEGES;
二、查看授权情况
USE mysql;
SELECT * FROM USER;
三、收回权限
与设置权限相似，只是将TO改为FROM
REVOKE ALL PRIVILEGES ON *.* FROM 'username'@'183.228.187.99'
