[debian-mysql] Bug#411672: mysql-server-5.0: Incorrect file format 'host'

[Danai SAE-HAN (韓達耐)]

Here's what I did to solve it.

I ran "mysqld --skip-grant" as root, then I logged in with "mysql" without any
password as user root.

Then I ran "repair table [bla] use_frm;" where [bla] represents all the names
of the tables that I found in /var/lib/mysql/mysql/ (without the suffix, of
course).  Now my mysql users had gone, but at least mysqld starts again.

Now I had to recreate two users in my database (root with supercow powers and
a regular user), and then ran "dpkg-reconfigure mysql-server-5.0" to configure
the debian-sys-maint user.

HTH


-- 
Danai SAE-HAN (韓達耐)
--
題目:《落花》
作者:宋祁（９９８－１０６２）

墜素翻紅各自傷，青樓煙雨忍相忘。
將飛更作回風舞，已落猶成半面妝。
滄海客歸珠有淚，章台人去骨遺香。
可能無意傳雙蝶，盡付芳心與蜜房。

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 252 bytes
Desc: OpenPGP digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20070708/d20171a4/attachment.pgp