mysqld won't start

[Aldo Foot]

On Jan 31, 2008 5:31 PM, Dave Stevens <geek at uniserve.com> wrote:
> On Thursday 31 January 2008 05:15:58 pm Aldo Foot wrote:
> > On Jan 31, 2008 4:34 PM, Dave Stevens <geek at uniserve.com> wrote:
> > > Hi,
> > >
> > > I have mysql installed in my F7 x86-64 system. When I try to use the
> > > System | Administration | Server Settings and highlight mysqld and click
> > > on start I get a delay and
> > >
> > > "mysqld failed. The error was: Timeout error occurred trying to start
> > > MySQL Daemon.
> > > Starting MySQL:  [FAILED]"
> > >
> > > This is less informative than I would like it to be.
>
> snip!
>
> > See if this will save you some time and effort:
> > Try removing the server and then reinstall it.
> >    yum remove mysql-server
> >    yum install mysql-server
> >
> > ~af
>
> Thanks, a good idea but no go:
>
>
> [root at localhost log]# tail mysqld.log
> 080131 17:28:44  InnoDB: Starting log scan based on checkpoint at
> InnoDB: log sequence number 0 36808.
> InnoDB: Doing recovery: scanned up to log sequence number 0 43655
> 080131 17:28:44  InnoDB: Starting an apply batch of log records to the
> database...
> InnoDB: Progress in percents: 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
> 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
> 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
> 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
> InnoDB: Apply batch completed
> 080131 17:28:45  InnoDB: Started; log sequence number 0 43655
> 080131 17:28:45 [ERROR] Fatal error: Can't open and lock privilege tables:
> Table 'mysql.host' doesn't exist
> 080131 17:28:45  mysqld ended
>
> other ideas?
>
>
> Dave


try uninstalling the mysql-server again, but this time
remove /var/lib/mysql and /etc/my.cnf. Backup them
up first in case you have something in there you need to keep.

then reinstall again.and do "service mysqld start"

~af