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