Keep Server Online
If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.
or
A donation makes a contribution towards the costs, the time and effort that's going in this site and building.
Thank You! Steffen
Your donations will help to keep this site alive and well, and continuing building binaries. Apache Lounge is not sponsored.
| |
|
Topic: How to connect remote MySql from PHP |
|
Author |
|
nagella
Joined: 28 Nov 2011 Posts: 27 Location: Pune
|
Posted: Tue 29 Nov '11 12:05 Post subject: How to connect remote MySql from PHP |
|
|
Hi Guys,
Can you please help me , i am running Apache and PHP from one Server , but my database server mysql is running some other server . So let me know
what are the steps required to fallow .
Please me know how to conncet by using both IP Address and Hostname .
* Me only installed MySql Server in the Server.
So can you please let me know steps required connect remote databse. |
|
Back to top |
|
James Blond Moderator
Joined: 19 Jan 2006 Posts: 7371 Location: Germany, Next to Hamburg
|
Posted: Tue 29 Nov '11 15:55 Post subject: |
|
|
On the remote host the tcp port 3360 has to be open and mysql must listen on tcp (which is default on windows).
You can connect over the IP. That is is easiest way. I've noticed that in a windows network with IPv6 mysql connector from php doesn't not connect over IPv6 IP. |
|
Back to top |
|
nagella
Joined: 28 Nov 2011 Posts: 27 Location: Pune
|
Posted: Thu 01 Dec '11 16:11 Post subject: yes, thats right |
|
|
Now are able to connet mysql server.
Thank you.. |
|
Back to top |
|
James Blond Moderator
Joined: 19 Jan 2006 Posts: 7371 Location: Germany, Next to Hamburg
|
Posted: Thu 01 Dec '11 16:34 Post subject: |
|
|
What was your issue? |
|
Back to top |
|
|
|
|
|
|