[Bug 248067] [NEW] mysql server can't be started: mysql.host doesn't exist

[Torsten Bronger]

Public bug reported:

Binary package hint: mysql-server-5.0

The MySQL server process can't be restarted:

bronger at wilson:~/src/chantal$ sudo /etc/init.d/mysql restart
 * Stopping MySQL database server mysqld                                                                                               [ OK ] 
 * Starting MySQL database server mysqld                                                                                               [fail] 

daemon.log says:

Jul 13 11:18:03 wilson mysqld_safe[7307]: started
Jul 13 11:18:03 wilson mysqld[7311]: 080713 11:18:03  InnoDB: Started; log sequence number 0 43685
Jul 13 11:18:03 wilson mysqld[7311]: 080713 11:18:03 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Jul 13 11:18:03 wilson mysqld_safe[7322]: ended

I haven't figured out which actions have led to this behaviour.  I'm not
aware of having made something unusual.

Re-installing mysql-server help but not for very long.

** Affects: mysql-dfsg-5.0 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
mysql server can't be started: mysql.host doesn't exist
https://bugs.launchpad.net/bugs/248067
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.