[debian-mysql] Bug#598828: mysql: [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

[Graham Cobb]

Package: mysql-common
Version: 5.1.49-1
Severity: important
File: mysql


I have just upgraded to kde4 in Squeeze.  As far as I remember, I have never 
used mysql on this system before but it is now used by Akonadi.

Akonadi fails its self test complaining about an error in the MySQL server log.
The mysql.err log contains:

101002  9:53:02 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
101002  9:53:06  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
101002  9:53:07  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 64 MB
InnoDB: Database physically writes the file full: wait...
101002  9:53:10  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 64 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
101002  9:53:15  InnoDB: Started; log sequence number 0 0
101002  9:53:16 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
101002  9:53:16 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
101002  9:53:16 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.49-1-log'  socket: '/home/cobb/.local/share/akonadi/db_misc/mysql.socket'  port: 0  (Debian)

I am assuming that, even though the problem is being reported by Akonadi,
it is actually a problem with mysql.

-- System Information:
Debian Release: squeeze/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.32-5-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_IE at euro, LC_CTYPE=en_IE at euro (charmap=ISO-8859-15) (ignored: LC_ALL set to en_IE at euro)
Shell: /bin/sh linked to /bin/bash

-- no debconf information