Gentoo Archives: gentoo-server

From: Jan Meier <jan.meier@××××××××××××××××.de>
To: gentoo-server@l.g.o
Subject: [gentoo-server] Problem with /var/run/mysqld.sock
Date: Fri, 01 Dec 2006 10:25:45
Message-Id: 200612011121.38139.jan.meier@zmnh.uni-hamburg.de
1 Hello,
2
3 I have a problem with the mysql-4.1.21 unix socket in /var/run/mysqld.sock
4 because if I do a:
5
6 mysql --no-defaults -u root -p ...
7 I get the following error:
8
9 ERROR 2002 (HY000): Can't connect to local MySQL server through
10 socket ''/var/run/mysqld/mysqld.sock'' (2)
11
12 The socket is created by mysql and ls -l shows the following:
13
14 -rw-rw---- 1 mysql mysql 6 Nov 30 16:11 mysqld.pid
15 srwxrwxrwx 1 mysql mysql 0 Nov 30 16:11 mysqld.sock
16
17 and ls -l /var/run/| grep mysql
18 drwxr-xr-x 2 mysql mysql 4096 Nov 30 16:11 mysqld
19
20 netstat -lpa | grep mysql has the following output:
21
22 unix 2 [ ACC ] STREAM LISTENING
23 18571846 - /var/run/mysqld/mysqld.sock
24
25 unix 3 [ ] STREAM CONNECTED
26 18690540 - /var/run/mysqld/mysqld.sock
27
28 Seems okay. But there are many CONNECTED entries. I upgraded from an earlier
29 mysql installation.
30
31 Any suggestions why the mysql and all the other programs which connect over
32 the socket are not able to connect? Could a reboot help?
33
34 Regards
35
36 Jan
37
38 --
39 gentoo-server@g.o mailing list

Replies

Subject Author
Re: [gentoo-server] Problem with /var/run/mysqld.sock Francesco Riosa <vivo@g.o>