1 |
Hello, |
2 |
|
3 |
This problem is well-known, and present in the bugzilla. The problem |
4 |
lies in MySQL 5.0.26-r1, and many threads in the forums have been spawned. |
5 |
|
6 |
- Neil |
7 |
|
8 |
On 14:14 Tue 24 Oct , A. R. wrote: |
9 |
> Hi, |
10 |
> |
11 |
> I am running Gentoo ~amd64 and I recently upgraded MySQL from |
12 |
> 5.0.26 to 5.0.26-r1 and things are not working anymore (for example mythtv). |
13 |
> |
14 |
> After spending a great deal of time looking at logs, changing |
15 |
> configuration files (namely, my.cnf), installing and de-installing |
16 |
> MySQL, I still cannot get any programs to connect to mysql, including |
17 |
> "mysql_secure_installation" which outputs the following error message: |
18 |
> |
19 |
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket |
20 |
> ''/var/run/mysqld/mysqld.sock'' (2) |
21 |
> |
22 |
> But, here is the thing, the socket and pid file values in |
23 |
> /etc/mysql/my.cnf are set to the following: |
24 |
> |
25 |
> [client] |
26 |
> socket = /tmp/mysqld.sock |
27 |
> . |
28 |
> . |
29 |
> [mysqld] |
30 |
> socket = /tmp/mysqld.sock |
31 |
> pid-file = /tmp/mysqld.pid |
32 |
> |
33 |
> |
34 |
> |
35 |
> And, after re-starting the MySQL process (/etc/init.d/mysql restart) I |
36 |
> list the processes and find that the mysqld daemon has indeed been |
37 |
> passed the correct configuration values. |
38 |
> |
39 |
> mysql 24056 1 0 11:20 ? 00:00:00 /usr/sbin/mysqld |
40 |
> --defaults-file=/etc/mysql/my.cnf --basedir=/usr |
41 |
> --datadir=/storage/mysql-db --pid-file=/tmp/mysqld.pid |
42 |
> --socket=/tmp/mysqld.sock |
43 |
> |
44 |
> |
45 |
> Could someone please help? |
46 |
> I know I am running ~arch and that this is perhaps "part of the game" |
47 |
> in doing that, but maybe it can be easily fixed... |
48 |
> |
49 |
> Thank you, |
50 |
> |
51 |
> - AR |
52 |
> |
53 |
> -- |
54 |
> If you stare long enough into an abyss, the abyss will stare back into |
55 |
> you... |
56 |
> -- |
57 |
> gentoo-user@g.o mailing list |
58 |
|
59 |
-- |
60 |
gentoo-user@g.o mailing list |