Not Able to Connect to Remote Database Server..

dushyantgohil · 08-27-2012, 02:40 AM

Hi,

I am having two servers, one is configured with lamp and another is wamp. now i am trying to connect database to lamp server to wamp server. i have made changes in configuration.php file according to the lamp server. but i am getting error.

"database connection error (2) could not connect to mysql"

Thanks:

banghead:

evo2 · 08-27-2012, 03:17 AM

Hi,

there are a number of things that could be causing this. For example

- mysql may be configured to only accept connections from the localhost
- there may be a firewall blocking the port
- etc.

To try to isolate the problem you should look at the logs on the machine running the mysql server. You can also try connecting to the msyql server via the command line to try to understand that is happening. For example

Code:

mysql --verbose --user=someone --password=secret --port=3306 --host=mymachine dbname

HTH,

Evo2.

dushyantgohil · 08-27-2012, 05:06 AM

Quote:

Originally Posted by evo2

Hi,

there are a number of things that could be causing this. For example

- mysql may be configured to only accept connections from the localhost
- there may be a firewall blocking the port
- etc.

To try to isolate the problem you should look at the logs on the machine running the mysql server. You can also try connecting to the msyql server via the command line to try to understand that is happening. For example

Code:

mysql --verbose --user=someone --password=secret --port=3306 --host=mymachine dbname

HTH,

Evo2.

thanks for reply evo
but i have checked firewall, but there is no any issue with it.
i have also connected database server via mysql workbench also and i can access database server via linux but not able to connect using windows with wamp.

evo2 · 08-27-2012, 04:10 PM

Hi,

have you tried it via the commandline on the windows box?

Evo2.

dushyantgohil · 08-28-2012, 01:20 AM

yes its working

evo2 · 08-28-2012, 01:35 AM

Hi,

Quote:

Originally Posted by dushyantgohil

yes its working

But using the exact same machine you can't connect using the same parameters in a php script?

Evo2.

dushyantgohil · 08-28-2012, 05:04 AM

exactly