I found your error here http://www.washington.edu/computing/web/publishing/mysql-install.html In this case, you have incorrectly specified the path to mysql.sock in your home directory. Look at step 9 and fix your ~/.my.cnf file http://www.washington.edu/computing/web/publishing/mysql-install.html#step9
I'm running gentoo as well. Here is the relavant section of my /etc/mysql/my.cnf pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock log-error = /var/log/mysql/mysqld.err I checked my system and I do not have a /var/lib/mysqld folder which, unless you created one, I think your problem is. Mysql can not start because it can not create a file in a directory that does not exist. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:mythtv-users- > [EMAIL PROTECTED] On Behalf Of al > Sent: Thursday, July 07, 2005 7:53 PM > To: Aaron Stewart > Cc: Discussion about mythtv > Subject: Re: [mythtv-users] MySQL errors, mysqld.sock > > I've tried the logs too. Applicable info: > > [mysql.err] > > 050706 07:03:48 mysqld started > 050706 7:03:48 Can't start server : Bind on unix socket: No such file > or directory > 050706 7:03:48 Do you already have another mysqld server running on > socket: /var/lib/mysqld/m$ > 050706 7:03:48 Aborting > > 050706 7:03:48 /usr/sbin/mysqld: Shutdown Complete > > 050706 07:03:48 mysqld ended > > 050707 18:57:11 mysqld started > 050707 18:57:12 mysqld ended > > [mysql.log] - nothing > > [mysqld.err] > > 050706 6:57:05 /usr/sbin/mysqld: Shutdown Complete > > InnoDB: The first specified data file ./ibdata1 did not exist: > InnoDB: a new database to be created! > 050707 18:57:11 InnoDB: Setting file ./ibdata1 size to 10 MB > InnoDB: Database physically writes the file full: wait... > 050707 18:57:11 InnoDB: Log file ./ib_logfile0 did not exist: new to be > created > InnoDB: Setting log file ./ib_logfile0 size to 5 MB > InnoDB: Database physically writes the file full: wait... > 050707 18:57:11 InnoDB: Log file ./ib_logfile1 did not exist: new to be > created > InnoDB: Setting log file ./ib_logfile1 size to 5 MB > InnoDB: Database physically writes the file full: wait... > InnoDB: Doublewrite buffer not found: creating new > InnoDB: Doublewrite buffer created > InnoDB: Creating foreign key constraint system tables > InnoDB: Foreign key constraint system tables created > 050707 18:57:12 InnoDB: Started; log sequence number 0 0 > 050707 18:57:12 [ERROR] Fatal error: Can't open privilege tables: > Table 'mysql.host' doesn't exist > > On 7/7/05, Aaron Stewart <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > > > > > > > > -- > Biostar M7NCG 400 > AMD Athlon XP 2000 > PVR 350 > nVidia GeForce4 MX 440 > S-vid out to SD TV > _______________________________________________ > 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
