Well, it says the "host.frm" file has the "wrong information".
Have you tried mysql_fix_permissions? Or starting the server with --skip-grant-tables? It's possible the table itself is corrupt. You could also try backing up the data you have and running mysql_install_db to re-create the hosts file. -Sheeri On 2/12/06, DonM <[EMAIL PROTECTED]> wrote: > On Saturday 11 February 2006 21:53, CasperLinux wrote: > > I had a working database then had a power glitch shutdown the computer. > > Afterwards I began receiving all sorts of errors. I cleaned through most > > of them but this one is stumping me. I tried to uninstall and reinstall > > mysql-server to no avail. Anyone have any kind words? > > > I have now tried to restore from a backup and get the same results. I really > don't know how to get this working. Tried the install_db script and it fails > for essentially the same problems. Anyone have a solution. I know this has > to be easy that's why I can't figure it out. Even a hint where to find > proper documentation cause I can't get the answer off google. > > > arthur:/etc/X11# mysqld > > 060211 21:50:22 InnoDB: Database was not shut down normally! > > InnoDB: Starting crash recovery. > > InnoDB: Reading tablespace information from the .ibd files... > > InnoDB: Restoring possible half-written data pages from the doublewrite > > InnoDB: buffer... > > 060211 21:50:22 InnoDB: Starting log scan based on checkpoint at > > InnoDB: log sequence number 0 43690. > > InnoDB: Doing recovery: scanned up to log sequence number 0 43736 > > InnoDB: Last MySQL binlog file position 0 79, file > > name /var/log/mysql/mysql-bin.000032 > > 060211 21:50:22 InnoDB: Flushing modified pages from the buffer pool... > > 060211 21:50:22 InnoDB: Started; log sequence number 0 43736 > > 060211 21:50:22 [ERROR] mysqld: Incorrect information in file: > > './mysql/host.frm' > > 060211 21:50:22 [ERROR] mysqld: Incorrect information in file: > > './mysql/host.frm' > > 060211 21:50:22 [ERROR] Fatal error: Can't open and lock privilege tables: > > Incorrect information in file: './mysql/host.frm' > > > > Don > > -- > > - Powered by Debian Linux - > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
