logo
Apache Lounge
Webmasters

 

About Forum Index Downloads Search Register Log in RSS X


Keep Server Online

If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.

or

Bitcoin

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.
Post new topic   Forum Index -> Other Software View previous topic :: View next topic
Reply to topic   Topic: How to connect remote MySql from PHP
Author
nagella



Joined: 28 Nov 2011
Posts: 27
Location: Pune

PostPosted: Tue 29 Nov '11 12:05    Post subject: How to connect remote MySql from PHP Reply with quote

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

PostPosted: Tue 29 Nov '11 15:55    Post subject: Reply with quote

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

PostPosted: Thu 01 Dec '11 16:11    Post subject: yes, thats right Reply with quote

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

PostPosted: Thu 01 Dec '11 16:34    Post subject: Reply with quote

What was your issue?
Back to top


Reply to topic   Topic: How to connect remote MySql from PHP View previous topic :: View next topic
Post new topic   Forum Index -> Other Software