Page 1 of 1

"cant connect to local MySQL server through socket

PostPosted: Tue Sep 19, 2006 7:25 am
by ssin14
I am having this error. Error number 2002.

PostPosted: Tue Sep 19, 2006 10:24 am
by enjay
Make sure the user running mysqld (typically mysql) has permissions to the /var/lib/mysql directory.

do you have any other errors when this happens? Like

/var/lib/mysql/mysql.sock already exists errors or anything?

PostPosted: Tue Sep 19, 2006 1:58 pm
by ssin14
no , only that error.

how can make it work?

PostPosted: Tue Sep 19, 2006 2:23 pm
by enjay
Look at the mysql log

/var/log/mysql.log

-enjay

PostPosted: Tue Sep 19, 2006 2:27 pm
by ssin14
thanks

it says No such file or directory

PostPosted: Tue Sep 19, 2006 2:29 pm
by enjay
/var/log/mysqld.log

PostPosted: Tue Sep 19, 2006 3:07 pm
by ssin14
well it says the samething again.

PostPosted: Tue Sep 19, 2006 3:30 pm
by ssin14
do i have to change the socket entries in "vi /etc/my.cnf"
change it to /var/run/mysql/mysql.sock instead of /tmp/mysql.sock