Apache + Connect to remote MySQL database (online)

[Philo]

Hi!

I'm trying to connect to a remote mysql database.
But It can't seem to reach it.

So I'm running Apache local, and I want to connect to a remote server for example: google.com

Somehow this is being blocked.
When I use my Mac with Mamp and try the same it seems to work fine.

Anyone has experience getting this working?

Thanks!

[JonB]

That's pretty UNCLEAR Philo

HOW do you want to connect to a remote database???

Using your own PHP code or a script???


Good Luck

[Philo]

Hi JonB,

I'm using PHP to connect to the remote database.
I've disabled the firewall and anti-virus / internet security.

But somehow it can't seem to reach the remote database.

For example:
mysql_connect('mydomain.com', 'mysql_user', 'mysql_password');

This works on my Mac but not on my Windows machine.

[JonB]

what's the error you are getting??

[Philo]

Unable to connect to the database.
I think it is a windows issue though, since I tried with multiple windows webservers.

[JonB]

OK, however I suspect that's not the case really.

Its probably a firewall or socket method issue. The best place to get advice on this would be a place like Stackoverflow or Daniweb (or the MySQL forums).

Good Luck

[rashed]

Hi!

I'm trying to connect to a remote mysql database.
But It can't seem to reach it.

So I'm running Apache local, and I want to connect to a remote server for example: google.com

Somehow this is being blocked.
When I use my Mac with Mamp and try the same it seems to work fine.

Anyone has experience getting this working?

Thanks!

Dear Philo,

You can try the following-

step 1:
create a user with anyhost in remote mysql server
e.g. user@*

step 2:

mysql_connect('host:port/opt/lampp/var/mysql/mysql.sock', 'user', 'password');

hope it will connect.

Thanks