Remote connect to a MySQL Server

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
bluenote
Forum Commoner
Posts: 93
Joined: Sat Mar 01, 2003 4:59 am
Location: Heidelberg, Germany

Remote connect to a MySQL Server

Post 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
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post 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 ;)
Post Reply