Re: Antwort: PHP and MySQL - Default Socket Setting
[EMAIL PROTECTED] wrote: On 01.03.2001 11:55:40 Ben Kennish wrote: "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" Are you sure that your MySQL installation creates the socket right there? If I'm not mistaken, it may be created in /tmp. - 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 No it was creating it in /var/lib/mysql but then PHP doesn't like this Thanks to you, we've managed to get it working using the following commands... mysqladmin shutdown safe_mysqld --user=root --socket=/tmp/mysql.sock This works but would you happen to know how I can get NySQL to create the socket in /tmp/ at startup? (rather than having to shut it down and reboot with a new socket) Cheers, -- 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
RE: Antwort: PHP and MySQL
I hd this same problem. Ensure that /var, /var/lib, and /var/lib/mysql have permissions set to: drwxr-xr-x This cured the problem for me. rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 6:19 AM To: Ben Kennish Cc: [EMAIL PROTECTED] Subject: Antwort: PHP and MySQL On 01.03.2001 11:55:40 Ben Kennish wrote: "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" Are you sure that your MySQL installation creates the socket right there? If I'm not mistaken, it may be created in /tmp. - 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
Re: Antwort: PHP and MySQL - Specifying location for mysql.sock
HOORAY! It's finally working. However, I'd prefer to have my mysql.sock socket file in /tmp/ Anyone know how to change the settings for MySQL (and also PHP4 and phpMyAdmin) so that it looks in /tmp/ instead? Cheers. Ben Rick Emery wrote: I hd this same problem. Ensure that /var, /var/lib, and /var/lib/mysql have permissions set to: drwxr-xr-x This cured the problem for me. rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 6:19 AM To: Ben Kennish Cc: [EMAIL PROTECTED] Subject: Antwort: PHP and MySQL On 01.03.2001 11:55:40 Ben Kennish wrote: "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" Are you sure that your MySQL installation creates the socket right there? If I'm not mistaken, it may be created in /tmp. - 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 -- 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