Re: System crash, Reboot, Incorrect information in file: './mysql/host.frm'

[Eric Gumtow]

I figured it out on my own. It wasn't easy.

1. Find your host.frm file.
2. Move host.* files (three of them) somewhere else, just to keep them.
3. Run /usr/bin/mysql_install_db
4. Run /etc/init.d/mysql start
5. You might hit other similar corrupted files, if so repeat from step 2.
6. With MySql now up, login as mysql root, no password.
7. Create MySql users and grant privileges as necessary on existing databases.