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

Yep. This one got me. /var/lib/mysql had these permissions: drwx------ Changed to: drwx-r-x-r-x Worked like a charm. Many thanks to Joe and Rick rick -----Original Message----- From: Joe Brown [mailto:joebrown@somewhere.com] Sent: Tuesday, February 27, 2001 10:24 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Can't connect to local MySQL server error Heh, hate this gotcha... The file permissions are good... ok, now check each directory up to mysql.loc /var /var/lib /var/lib/mysql Does the world have read and execute perms on all of the above (hehe made a funny)? Without read and execute perms on the parent directories, the world cannot see the file to have read write and execute to the socket file. gl "Rick Emery" <remery@excel.com> wrote in message news:EAA093B474ABD311A71E00508B5FE083021B88E2@adntex03.us.excel.com... > 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 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net