xampp的mysql允许远程访问

Check you have enabled remote access to the MySQL server. Open the my.cnf file (probably found inside xampp/etc/), go to the [mysqld] section and add the following (using your own ip address instead of the example)

bind-address=192.168.1.100

当然还需要修改user那张表下面的host，改成%，比如要让root远程可访问，就用把root的host设置成100%

原文：http://www.cnblogs.com/yanghuaifa/p/5737522.html