On 06-07-07 08:36, sean finney wrote: > >> Isn't there some tool with which I could fix this "host" privilege table? > > have you tried manually running mysql_fix_privilege_tables ?
Indeed I have, but it can't connect to /var/run/mysqld/mysqld.sock because I can't start mysqld. :/ I think most tools to fix tables require mysqld to run, so I'm in a pretty difficult situation. Here's the content of /var/lib/mysql/mysql: totaal 716 drwxr-xr-x 2 mysql mysql 4096 2007-07-06 00:27 . drwxr-xr-x 4 mysql mysql 155 2007-07-06 00:49 .. -rw-rw---- 1 mysql mysql 8820 2007-06-09 19:25 columns_priv.frm -rw-rw---- 1 mysql mysql 0 2007-06-09 19:25 columns_priv.MYD -rw-rw---- 1 mysql mysql 1024 2007-06-09 19:25 columns_priv.MYI -rw-rw---- 1 mysql mysql 9494 2007-06-09 19:25 db.frm -rw-rw---- 1 mysql mysql 1314 2007-06-09 19:25 db.MYD -rw-rw---- 1 mysql mysql 4096 2007-06-09 19:25 db.MYI -rw-rw---- 1 mysql mysql 8665 2007-06-09 19:25 func.frm -rw-rw---- 1 mysql mysql 0 2007-06-09 19:25 func.MYD -rw-rw---- 1 mysql mysql 1024 2007-06-09 19:25 func.MYI -rw-rw---- 1 mysql mysql 8700 2006-07-09 23:52 help_category.frm -rw-rw---- 1 mysql mysql 20916 2007-07-06 00:27 help_category.MYD -rw-rw---- 1 mysql mysql 3072 2007-07-06 00:27 help_category.MYI -rw-rw---- 1 mysql mysql 8612 2006-07-09 23:52 help_keyword.frm -rw-rw---- 1 mysql mysql 75845 2007-07-06 00:27 help_keyword.MYD -rw-rw---- 1 mysql mysql 13312 2007-07-06 00:27 help_keyword.MYI -rw-rw---- 1 mysql mysql 8630 2006-07-09 23:52 help_relation.frm -rw-rw---- 1 mysql mysql 6723 2007-07-06 00:27 help_relation.MYD -rw-rw---- 1 mysql mysql 13312 2007-07-06 00:27 help_relation.MYI -rw-rw---- 1 mysql mysql 8770 2006-07-09 23:52 help_topic.frm -rw-rw---- 1 mysql mysql 332964 2007-07-06 00:27 help_topic.MYD -rw-rw---- 1 mysql mysql 15360 2007-07-06 00:27 help_topic.MYI -rw-rw---- 1 mysql mysql 9416 2007-06-09 19:25 host.frm -rw-rw---- 1 mysql mysql 0 2007-06-09 19:25 host.MYD -rw-rw---- 1 mysql mysql 1024 2007-06-09 19:25 host.MYI -rw-rw---- 1 mysql mysql 9691 2007-06-09 19:25 proc.frm -rw-rw---- 1 mysql mysql 0 2007-06-09 19:25 proc.MYD -rw-rw---- 1 mysql mysql 1024 2007-06-09 19:25 proc.MYI -rw-rw---- 1 mysql mysql 8875 2007-06-09 19:25 procs_priv.frm -rw-rw---- 1 mysql mysql 0 2007-06-09 19:25 procs_priv.MYD -rw-rw---- 1 mysql mysql 1024 2007-06-09 19:25 procs_priv.MYI -rw-rw---- 1 mysql mysql 8947 2007-06-09 19:25 tables_priv.frm -rw-rw---- 1 mysql mysql 0 2007-06-09 19:25 tables_priv.MYD -rw-rw---- 1 mysql mysql 1024 2007-06-09 19:25 tables_priv.MYI -rw-rw---- 1 mysql mysql 8636 2007-04-06 00:13 time_zone.frm -rw-rw---- 1 mysql mysql 8624 2006-07-09 23:52 time_zone_leap_second.frm -rw-rw---- 1 mysql mysql 0 2007-07-06 00:27 time_zone_leap_second.MYD -rw-rw---- 1 mysql mysql 1024 2007-07-06 00:27 time_zone_leap_second.MYI -rw-rw---- 1 mysql mysql 0 2007-07-06 00:27 time_zone.MYD -rw-rw---- 1 mysql mysql 1024 2007-07-06 00:27 time_zone.MYI -rw-rw---- 1 mysql mysql 8606 2006-07-09 23:52 time_zone_name.frm -rw-rw---- 1 mysql mysql 0 2007-07-06 00:27 time_zone_name.MYD -rw-rw---- 1 mysql mysql 1024 2007-07-06 00:27 time_zone_name.MYI -rw-rw---- 1 mysql mysql 8686 2006-07-09 23:52 time_zone_transition.frm -rw-rw---- 1 mysql mysql 0 2007-07-06 00:27 time_zone_transition.MYD -rw-rw---- 1 mysql mysql 1024 2007-07-06 00:27 time_zone_transition.MYI -rw-rw---- 1 mysql mysql 8748 2006-07-09 23:52 time_zone_transition_type.frm -rw-rw---- 1 mysql mysql 0 2007-07-06 00:27 time_zone_transition_type.MYD -rw-rw---- 1 mysql mysql 1024 2007-07-06 00:27 time_zone_transition_type.MYI -rw-rw---- 1 mysql mysql 10330 2007-06-09 19:25 user.frm -rw-rw---- 1 mysql mysql 600 2007-06-09 19:25 user.MYD -rw-rw---- 1 mysql mysql 2048 2007-06-09 19:25 user.MYI # grep -i host * Binair bestand columns_priv.frm komt overeen Binair bestand db.frm komt overeen Binair bestand help_keyword.MYD komt overeen Binair bestand help_keyword.MYI komt overeen Binair bestand help_topic.MYD komt overeen Binair bestand help_topic.MYI komt overeen Binair bestand host.frm komt overeen Binair bestand procs_priv.frm komt overeen Binair bestand tables_priv.frm komt overeen Binair bestand user.frm komt overeen This is the output of my syslog: Jul 6 10:18:01 danai mysqld_safe[13766]: started Jul 6 10:18:02 danai mysqld[13769]: InnoDB: Warning: we did not need to do crash recovery, but log scan Jul 6 10:18:02 danai mysqld[13769]: InnoDB: progressed past the checkpoint lsn 0 43630235 up to lsn 0 43630245 Jul 6 10:18:02 danai mysqld[13769]: 070706 10:18:02 InnoDB: Started; log sequence number 0 43630235 Jul 6 10:18:02 danai mysqld[13769]: 070706 10:18:02 [Note] Recovering after a crash using /var/log/mysql/mysql-bin Jul 6 10:18:02 danai mysqld[13769]: 070706 10:18:02 [Note] Starting crash recovery... Jul 6 10:18:02 danai mysqld[13769]: 070706 10:18:02 [Note] Crash recovery finished. Jul 6 10:18:03 danai mysqld[13769]: 070706 10:18:03 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host' Jul 6 10:18:03 danai mysqld_safe[13789]: ended Jul 6 10:18:16 danai /etc/init.d/mysql[13918]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jul 6 10:18:16 danai /etc/init.d/mysql[13918]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Jul 6 10:18:16 danai /etc/init.d/mysql[13918]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Jul 6 10:18:16 danai /etc/init.d/mysql[13918]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Jul 6 10:18:16 danai /etc/init.d/mysql[13918]: Best regards -- Danai SAE-HAN (韓達耐) -- 題目:《臨安春雨初霽》 作者:陸游(1125-1210) 世味年來薄似紗,誰令騎馬客京華。 小樓一夜聽春雨,深巷明朝賣杏花。 矮紙斜行閑作草,晴窗細乳戲分茶。 素衣莫起風塵嘆,猶及清明可到家。
signature.asc
Description: OpenPGP digital signature