Page 1 of 1

Remote connect to a MySQL Server

Posted: Thu Feb 05, 2004 5:52 am
by bluenote
Hi there,

perhaps it's just the same as with my last posting and i am too :roll: to see the solution...

Anyway: I have a MySQL Server running on a Solaris machine (Solaris 7 Server, MySQL 3.23.53) and performing quite well.

Until yesterday, the whole PHP / Apache thing both for Intranet and WWW where on the same (this) machine.

But today, i have to seperate them: Intranet (with PHP / Apache) on solaris-1, WWW pages (with ...) on solaris-2 and the database on solaris-3. Both solaris-1 and solaris-2 should be able to connect to the database server to retrieve (solaris-2) or to post & retrieve (solaris-1, Intranet) data.

How... :?: Any comments or suggestions are welcome.

Thanx in advance,
-bluenote

Posted: Thu Feb 05, 2004 6:12 am
by timvw
Just make sure your database servers listens to TCP/IP connections too? In my.cnf there is an option skip-networking (make sure that is commented) and allow incoming tcp connections on port 3306 on that machine ;)