Muitiple MySQL Database Server

Anon

I have problem ?

I install mysql server database two version on same machine
One version is 3.23.16(Used port=3306) and Two is 3.23.21(Used port=2206)
and I install Apache+PHP+MySQl But Php connect to mysql server at port is
3306 Only .It cann\'t connect to Mysql Server port is 2206

==================================================
mysql_connect(\"localhost\",\"joe\",\"joe\"); // It work

mysql_connect(\"localhost:2206\",\"joe\",\"joe\"); // not work

==================================================

If someone know.Please help me.

Thank you sir.

Anon

1.check your php version.(Support for ":port" was added in PHP 3.0B4.)

check the port 2206.(netstat -a | grep 2206)

But it's not a good idea to start two mysql server with deferent version.

Good Lucky.

Anon

To chengong
I used PHP 4.0 and port (3306,2206) is ok and
I can use mysql server both version on linux system .
And I can access by port 3306 only but port 2206 not work for PHP 4.0

Thank you sir.

Anon

Try using the latest version of php (php4.0.1pl2) we also had this problem. We run an instance for each user of and they all run on different ports.

PHP3 worked find but PHP4.0 had a bug, this was fixed once we reported it.

Also you can use unix sockets rather then ports you will find this is quicker.

Regards
Darren
http://www.php4hosting.com/