Connecting to a second MySQL server(4.0.2) thru the socket...
| From: | Gurhan Ozen | 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