Remote SQL connection problem

asked Sep 26, 2013 in Database 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 like 0 dislike
answered 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 like 0 dislike
answered Sep 26, 2013 by TopNet
You can test the connection using telnet $yourhostname 3306 or mysql -h $yourhostname
...