原来使用Dreamhost的主机,我记得设置mysql数据库的远程连接很方便,换了Hostmonster的主机后一直没有找到地方哪里设置。。。

今天给主机续费,碰巧发现了Hostmonster的mysql远程连接设置,见图最省事:

1

竟然是在“billing information” 这里。。。晕倒

继续:

customer preferences

点击按钮:

mysql whitelisted ips

这里你可以设置使用单个IP,或者使用你现在所处的IP段!

 

然后你稍等一下就可以远程连接HostMonster的Mysql数据库了,当然最好设置一个强壮的密码先!

 

MySQL Whitelist

In order to remotely access your databases, we must allow the connection through our firewall. To do this, we allow you to specify a list of IPs (or Class C’s) to whitelist (always allow). No other IPs will be allowed to access your databases.

If you do not have any MySQL databases or you do not have any need to access them remotely (this does not include accessing from within your website, that is still a local connection), then you won’t need to modify this list.