Look in /var/log/mysql/* and see if that points to problems. I've had a similar issue, but it was one of those things I just blew through without thinking about what it was, so I'm crossing my fingers that it's something simple.
-=Aaron al wrote: >Long time reader, first time poster. > >Problem: MySQL no longer connects to the mysqld server. > >History: I setup a Knoppmyth frontend/backend system (see specs in >sig, rather vanilla setup) about a year ago. Recently I started over >from scratch on Gentoo to learn more about the system. > >After installing everything, I had a working MythTV frontend/backend >system. However, it took me a few weeks to get the IR blaster working. >The first time I tried MythTV after fixing the IR blaster, mythbackend >failed. I traced the problem back to MySQL. I could no longer connect >to the mysqld server or databases. > >I've read up on MySQL troubleshooting but have not found success with >the common suggestions. I have verified all permissions on the >applicable directories (/var/lib/mysql, /var/run/mysqld, etc). I have >a "mysql" user and "mysql" group. I do not have a mysqld.sock, which I >understand is created upon running the server. I can't create it. I >have verified that the mysqld.sock is not in /tmp. I've tried >unmerging/ re-emerging MySQL several times, even upgrading to MySQL >4.1.12. > >here is some applicable info about my problem: > ># mysqladmin -u root password new-password >mysqladmin: connect to server at 'localhost' failed >error: 'Can't connect to local MySQL server through socket >'/var/run/mysqld/mysqld.sock' (2)' >Check that mysqld is running and that the socket: >'/var/run/mysqld/mysqld.sock' exists! > ># ps aux | grep mysqld >root 28316 0.0 0.1 1484 436 pts/0 R+ 19:03 0:00 grep mysqld > ># mysqld_safe >Starting mysqld daemon with databases from /var/lib/mysql >STOPPING server from pid file /var/run/mysqld/mysqld.pid >050707 18:57:12 mysqld ended > >Can anyone help me? Since this is a new installation, I have no >database to save. I can destroy/create new databases as needed. > >TIA, >-Al >_______________________________________________ >mythtv-users mailing list >[email protected] >http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users > > _______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
