2

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?

Improve this question
5
  • 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, 2010 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, 2010 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, 2010 at 17:51
  • Is it possible to ping that specific port?
    – payling
    Jul 8, 2010 at 17:54
  • You really should be discussing this with your hosting provider.
    – John Gardeniers
    Jul 9, 2010 at 1:35

2 Answers 2

Reset to default
4

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.

Improve this answer
1
  • It turns out that the server providers blocks (firewall) the required connections to interface directly with the database.
    – payling
    Sep 7, 2010 at 13:49
1

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

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .