|
|
Posted by Gordon Burditt on 05/09/05 23:58
>Thanks for the suggestion, as you said, it's very unlikely.
>
>the mysql.sock ishave a permission like this.
>srwxrwxrwx 1 mysql mysql 0 May 9 13:30 mysql.sock
>
>which should be accessible by everyone.
So what are the permissions on /var/lib/mysql?
That matters.
>I have another php program calling the database that I migrated and it
>worked fine..so i'm really puzzled and scratching my head hard.
It could also happen that PHP and MySQL disagree on where the
socket is located.
If you have another PHP page that can access MySQL, running the same
instance of PHP on the same system running Apache, something wierd is
going on.
How did you migrate the database? If you did a UNIX-level copy,
it is possible that some of the files in the database have the wrong
owner so *MySQL* can't read/write them.
>
>a netstat -ln | grep mysql showed this
>unix 2 [ ACC ] STREAM LISTENING 1912679
>/var/lib/mysql/mysql.soc
>
>so it is listening for connection...
An error of 'permission denied' means it can't open the socket (or
some file), which is pretty much independent of whether anything
is listening on it or not.
Gordon L. Burditt
Navigation:
[Reply to this message]
|