Apache and MySQL on different Servers

westlm01 · 12-19-2005, 02:45 AM

Hey All,

I have Apache running on a Dedicated Server at home, for the sake of this post we will call this server1. I also have a dedicated server running MySQL and once again we will call this server2. Is is possible for apache on server1 to see and use the database on server2?

Any Solutions are appriciated!

Cheers All

Matthew

megaspaz · 12-19-2005, 02:57 AM

sure it is... because apache has nothing to do with mysql and knows nothing about mysql. You would communicate with mysql through php or cgi scripts like perl or python or java or whatever that has their respective mysql modules installed. These would be on the same machine as your apache server or need to be installed on the same machine as where your apache server is running.

denver1980 · 12-19-2005, 03:01 AM

If your network is safe, you can just go ahead and go plain text ...
I'm presuming that you have an entry in server1's /etc/hosts for server2 :

Code:

192.168.x.x   server2

When you connect to your DB in a PHP page :

Code:

$Session = mysql_connect(server2, Your_MySQL_User, Your_password) or die (Error_Message);

Be sure to allow connection to your MySQL DB from that user/host combination ...

Edit :
To allow your user from another host, use the GRANT syntax.
This will add the appropriate entry to you mysql.db table