[Solved] Remote Mysql Connection Problem

[dt340a]

I have only just setup my account about 24hrs ago.

I am able to log into the server remotely from home with the following:

mysql -u dt340a -h dt340a.heliohost.org -p

 

But I am having problem trying to log in from a different computer in college (times out when connecting). But both computers have been setup the same.

I have enabled remote hosts through cPanel with %.

 

So not really sure what the problem is. Any help would be great.

[Krydos]

It sounds like your college network is blocking port 3306. You could ask them about it, or only connect from the other computer that isn't blocked.

[dt340a]

Thanks Krydos. Is there an easy way to test whether this is the case or not. Would connecting to localhost on 3306 prove anything?

[Krydos]

It depends on the firewall. If the firewall is installed on each computer (unlikely) then it might even block 127.0.0.1:3306, but even if it was installed on each computer it could be configured to allow the computer to connect to any local port. Most likely it is just a network wide firewall.

 

If you just use phpmyadmin in your cpanel account you can type mysql queries, and it uses port 80 so nothing should be blocked about it. You could also talk to the network administrators to ask them to allow you to use port 3306.