You have to edit your "php.ini" file, usually located in /usr/local/lib.
There is an option called "mysql.default_socket". The value of this options
is the path to the mysql socket file. Your systems seems to search the
socket file at "/var/lib/mysql/mysql.sock". It might be at a different
place, probably "/tmp/mysql.sock".
Tobias.
-----Ursprüngliche Nachricht-----
Von: root [mailto:root]Im Auftrag von Ben Kennish
Gesendet: Donnerstag, 1. März 2001 11:56
An: [EMAIL PROTECTED]
Betreff: PHP and MySQL
Who would've thought it would take 3 days to install MySQL, PHP and get
them talking???!!
I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com
I've also installed MySQL (latest ver) server and client versions from
www.mysql.com using RPMs.
Now MySQL seems to be up and working (using 'mysql' and 'mysqladmin'
gives me no trouble) and PHP seems to work fine <?php phpinfo(); ?>.
I've installed the PHP-MySQL module from redhat.com (a single file -
mysql.so) and uncommented the "extension=mysql.so" line in /etc/php.ini
But when I type ...
mysql_connect('localhost', 'root', 'b');
into a PHP file, (I set b as my root SQL pwd) I get the following
error...
"Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/var/www/html/index.php on line 5"
There seems to be nothing in the MySQL error log.
Please help! Thanks,
--
Ben Kennish
Software Developer
Fubra Limited
web | www.fubra.net
email | [EMAIL PROTECTED]
phone | +44 (0)870 1222 600
fax | +44 (0)870 1222 699
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
