Web Hosting Geeks | Web Hosting Experts
Need help? Call us 1(866)TOP-HOST

14611 reviews 1734 hosting providers

Questions & Answers

Remote SQL connection problem

Sep 26, 2013 by yammi
Hey there

I  want to populate my DB using a remote SQL connections. Now I have an SQL server and I have everything set for the connection but I still cannot connect. Are there any specific tools or software that I can use to text the connection. Any suggestions are highly appreciated
Many thanks

3 Answers

0 votes
Sep 26, 2013 by SmartHost
Here’s what you need to do:
 First make sure that your server bounds to 0.0.0.0 instead of localhost
Then make sure your firewall is open and you assign necessary user permissions in order  to connect from your remote host
0 votes
Sep 26, 2013 by TopNet
You can test the connection using telnet $yourhostname 3306 or mysql -h $yourhostname
0 votes
Sep 26, 2013 by tareq101