Remote SQL connection problem

76 views
asked Sep 26, 2013 in Database by yammi (440 points)
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 (9,060 points)
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 (10,360 points)
You can test the connection using telnet $yourhostname 3306 or mysql -h $yourhostname
0 like 0 dislike
...