Connecting to a second MySQL server(4.0.2) thru the socket...

From: Date: Sat, 13 Jul 2002 12:11:14 +0000
Subject: Connecting to a second MySQL server(4.0.2) thru the socket...
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-20527@lists.php.net to get a copy of this message
Does everyone have any experiences connecting to MySQL 4.0.2 through the socket ? Here is the deal, I have just installed MySQL 4.0.2 as the second mysqld server on my linux machine, and , to specify which mysql to connect to , I am trying to connect to 4.0.2 via socket in PHP, i.e. mysql_connect("localhost:/var/tmp/mysql.sock", "user", "pass"); . Unfortunately, this fails, I do know that MySQL 4.0.2 is up and running thru the socket /var/tmp/mysql.sock . I can login to it thru the command line: [root@atsiz /root]# mysql --socket=/var/tmp/mysql.sock -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 to server version: 4.0.2-alpha Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> The weirdest thing is that I have done the exact same coding/procedure with 4.0.1 and it did work just fine... (Including the same socket path) . Any ideas?? Thanks in advance Gurhan

« previous php.db (#20527) next »