Hello, This problem is well-known, and present in the bugzilla. The problem lies in MySQL 5.0.26-r1, and many threads in the forums have been spawned.
- Neil On 14:14 Tue 24 Oct , A. R. wrote: > Hi, > > I am running Gentoo ~amd64 and I recently upgraded MySQL from > 5.0.26 to 5.0.26-r1 and things are not working anymore (for example mythtv). > > After spending a great deal of time looking at logs, changing > configuration files (namely, my.cnf), installing and de-installing > MySQL, I still cannot get any programs to connect to mysql, including > "mysql_secure_installation" which outputs the following error message: > > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > ''/var/run/mysqld/mysqld.sock'' (2) > > But, here is the thing, the socket and pid file values in > /etc/mysql/my.cnf are set to the following: > > [client] > socket = /tmp/mysqld.sock > . > . > [mysqld] > socket = /tmp/mysqld.sock > pid-file = /tmp/mysqld.pid > > > > And, after re-starting the MySQL process (/etc/init.d/mysql restart) I > list the processes and find that the mysqld daemon has indeed been > passed the correct configuration values. > > mysql 24056 1 0 11:20 ? 00:00:00 /usr/sbin/mysqld > --defaults-file=/etc/mysql/my.cnf --basedir=/usr > --datadir=/storage/mysql-db --pid-file=/tmp/mysqld.pid > --socket=/tmp/mysqld.sock > > > Could someone please help? > I know I am running ~arch and that this is perhaps "part of the game" > in doing that, but maybe it can be easily fixed... > > Thank you, > > - AR > > -- > If you stare long enough into an abyss, the abyss will stare back into > you... > -- > gentoo-user@gentoo.org mailing list -- gentoo-user@gentoo.org mailing list
