up vote 1 down vote favorite
share [g+] share [fb]

Our company hosts our server off site through another company who provides web hosting.

I ftp and plesk control panel as means of accessing. Plesk control panel has phpMyAdmin installed so that I can interface with the database "directly".

I've download MySQL query browser and I've been attempting to connect to the database server using that with no luck.

I recieve a MySQL Error Number 2003 when trying to connnect using MySQL query builder. I've read that error code could mean anything from a wrong port to username and password.

Is there a better way to diagnose why I can't connect?

link|improve this question
57% accept rate
1  
Have you verified with your hosting company that they allow the incoming MySQL connections through their firewall? This is most likely the issue. – Coding Gorilla Jul 8 '10 at 17:28
When I ping the server with the MySQL query browser I get responses. Does that mean that It's not blocked by a firewall? – payling Jul 8 '10 at 17:32
Not necessarily, they may have the firewall allowing pings through, but still blocking port 3306. You need to ask them if they allow connections on port 3306 (that's the MySQL port). – Coding Gorilla Jul 8 '10 at 17:51
Is it possible to ping that specific port? – payling Jul 8 '10 at 17:54
You really should be discussing this with your hosting provider. – John Gardeniers Jul 9 '10 at 1:35
feedback

2 Answers

up vote 2 down vote accepted

Error 2003 indicates that the connection has been refused. This could be because a firewall blocks it, or because the mysql server is configured only to allow unix socket connections which can only be local, or only local ip connections via the 127.0.0.1 interface.

You need to examine the mysql configuration file in /etc to see how it is configured if you have the access rights for it. Otherwise you probably will not be able to change it anyway, since you might need to change this file if it is configured in this way.

However, you should be very careful if you allow remote connections, since they could also be a security problem.

link|improve this answer
It turns out that the server providers blocks (firewall) the required connections to interface directly with the database. – payling Sep 7 '10 at 13:49
feedback
up vote 0 down vote

Most hosting company does not allow remote connections due to security reason, you may ask them thru their support if they allow remote connection to your database. I am also looking for hosting that will allow remote database connection. Hope it may help.

Kenneth

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.