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" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 26, 2001 4:46 PM
> To: Rick Emery; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Can't connect to local MySQL server error
>
>
> Addressed to: Rick Emery <[EMAIL PROTECTED]>
> '[EMAIL PROTECTED]'
>
> ** Reply to note from Rick Emery <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
