mysql 连接控制 Connection Verification
host配置 的示例
| Host Value | User Value | Permissible Connections |
| 'thomas.loc.gov' | 'fred' | fred, connecting from thomas.loc.gov |
| 'thomas.loc.gov' | '' | Any user, connecting from thomas.loc.gov |
| '%' | 'fred' | fred, connecting from any host |
| '%' | '' | Any user, connecting from any host |
| '%.loc.gov' | 'fred' | fred, connecting from any host in the loc.gov domain |
| 'x.y.%' | 'fred' | fred, connecting from x.y.net, x.y.com, x.y.edu, and so on; this is probably not useful |
| '144.155.166.177' | 'fred' | fred, connecting from the host with IP address 144.155.166.177 |
| '144.155.166.%' | 'fred' | fred, connecting from any host in the 144.155.166 class C subnet |
| '144.155.166.0/255.255.255.0' | 'fred' | Same as previous example |
bind-address
如果远程登录不上，可能是my.ini中设置了：
bind-address=127.0.0.1
解决方法：注释掉即可。
参考
http://dev.mysql.com/doc/refman/5.1/en/connection-access.html