RE: [PHP-DB] Can't connect to local MySQL server error

MySQL is running; I can execute MySQL as ROOT. The /var/lib/mysql/mysql.sock file exists with read/write/execute permissions to user/group/world. Any other ideas are appreciated. Thanks rick Richard L. Emery IT Sr. Project Manager "There is no 'trying'... There is only 'Do' or 'Not Do' " -----Original Message----- From: php3@developersdesk.com [mailto:php3@developersdesk.com] Sent: Monday, February 26, 2001 4:46 PM To: Rick Emery; php-db@lists.php.net Subject: RE: [PHP-DB] Can't connect to local MySQL server error Addressed to: Rick Emery <remery@excel.com> 'php-db@lists.php.net' ** Reply to note from Rick Emery <remery@excel.com> Mon, 26 Feb 2001 14:33:32 -0600 > > I tried: Grant ALL ON *.* to user@localhost IDENIFIED BY "password"; > so as to provide access to all tables. I should have stated that the error > I got was that I could not connect to the > /var/lib/mysql/mysql.sock socket. Make sure that MySQL is running, that the mysql.sock file exitst, in the specified location, and that the permsiions on that file, and every directory above it allow the user the web server runs as has read and execute rights. Note that execute for directories means that you can cd to it, and has nothing about running programs from within it. If the file is missing, try to find it (locate) and look in php.ini for a setting to specify the correct location for your system. Rick Widmer Internet Marketing Specialists http://www.developersdesk.com