[PHP-DB] pls clue in the clueless..:)
Hi all, I am having a problem that I have not seen in the past and thought to post it here. I am running mysql-3.23.54, php-4.3.0 and apache 1.3.27. Everything seems to install and work correctly...ie stuff like ?php phpinfo() ? works just fine. Now what is broken is mysql_connect(). I get the following error: Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/www/htdocs/test.php on line 2 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/www/htdocs/test.php on line 2 Could not connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) It is not a passwd or server running issue and the mysql server is running local to the web server. I can use a mysql client to connect to the server just fine. Any ideas? I am wondering if the internal mysql support for php is broken. Thanks in advance sroy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] pls clue in the clueless..:)
At 12:27 AM 1/8/03 -0800, Shantu Roy wrote: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/www/htdocs/test.php on line 2 Could not connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) It is not a passwd or server running issue and the mysql server is running local to the web server. I can use a mysql client to connect to the server just fine. Any ideas? I bet you don't have a mysql.sock file in /tmp/. There will be one on your system somewhere. Run the MySQL client and execute the status command \s to find the proper location. Then edit your php.ini file. Find the setting for mysql.default_socket and set it to the proper location. You must restart Apache for php.ini changes to take effect. Rick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[Fwd: Re: [PHP-DB] pls clue in the clueless..:)]
oops forgot to forward ---BeginMessage--- Rick Widmer wrote: At 12:27 AM 1/8/03 -0800, Shantu Roy wrote: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/www/htdocs/test.php on line 2 Could not connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) It is not a passwd or server running issue and the mysql server is running local to the web server. I can use a mysql client to connect to the server just fine. Any ideas? I bet you don't have a mysql.sock file in /tmp/. There will be one on your system somewhere. Run the MySQL client and execute the status command \s to find the proper location. Then edit your php.ini file. Find the setting for mysql.default_socket and set it to the proper location. You must restart Apache for php.ini changes to take effect. Rick Good thought but it seems like the socket file is being created. ---End Message--- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
