"cant connect to local MySQL server through socket

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

"cant connect to local MySQL server through socket

Postby ssin14 » Tue Sep 19, 2006 7:25 am

I am having this error. Error number 2002.
ssin14
 
Posts: 178
Joined: Mon Sep 04, 2006 4:45 am

Postby enjay » Tue Sep 19, 2006 10:24 am

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?
enjay
 
Posts: 806
Joined: Mon Jun 19, 2006 12:40 pm
Location: Utah

Postby ssin14 » Tue Sep 19, 2006 1:58 pm

no , only that error.

how can make it work?
ssin14
 
Posts: 178
Joined: Mon Sep 04, 2006 4:45 am

Postby enjay » Tue Sep 19, 2006 2:23 pm

Look at the mysql log

/var/log/mysql.log

-enjay
enjay
 
Posts: 806
Joined: Mon Jun 19, 2006 12:40 pm
Location: Utah

Postby ssin14 » Tue Sep 19, 2006 2:27 pm

thanks

it says No such file or directory
ssin14
 
Posts: 178
Joined: Mon Sep 04, 2006 4:45 am

Postby enjay » Tue Sep 19, 2006 2:29 pm

/var/log/mysqld.log
enjay
 
Posts: 806
Joined: Mon Jun 19, 2006 12:40 pm
Location: Utah

Postby ssin14 » Tue Sep 19, 2006 3:07 pm

well it says the samething again.
ssin14
 
Posts: 178
Joined: Mon Sep 04, 2006 4:45 am

Postby ssin14 » Tue Sep 19, 2006 3:30 pm

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
ssin14
 
Posts: 178
Joined: Mon Sep 04, 2006 4:45 am


Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 59 guests