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 > >mythtv-users@mythtv.org > >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 mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users