Skip navigation links

MySQL Forums :: Install :: MySQL fails to start because of missing mysql.plugin table


Advanced Search

MySQL fails to start because of missing mysql.plugin table
Posted by: Pablo Rauzy ()
Date: September 04, 2010 05:31PM

Hello,

I have a web server running on Debian, I just did an update from Lenny to Squeeze and since then MySQL won't start.

Here is what happens when I try to run it (this is the output of `sudo /usr/sbin/mysqld` since the startup script in /etc/init.d redirect the output to /dev/null. I know it writes to syslog but it's exactly the same output) :

100905  1:21:29 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
100905  1:21:29 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
100905  1:21:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100905  1:21:29  InnoDB: Started; log sequence number 0 44044
100905  1:21:29 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
100905  1:21:29 [ERROR] Aborting

100905  1:21:29  InnoDB: Starting shutdown...
100905  1:21:34  InnoDB: Shutdown completed; log sequence number 0 44044
100905  1:21:34 [Note] /usr/sbin/mysqld: Shutdown complete

I don't know where the --skip-bdb option comes from, I grep'ed it in the various script that mysql provide and didn't find even a single occurence of it.

Also I tried to run mysql_upgrade as suggested but, as expected, it needs to have the mysql server running...

If anyone could help me I would be really grateful!
Thanks :-).

EDIT: of course I forget one of the most important info... It's "mysqld Ver 5.1.49-1 for debian-linux-gnu on i486" from the mysql-server-5.1 debian package.



Edited 1 time(s). Last edit at 09/04/2010 05:33PM by Pablo Rauzy.

Options: ReplyQuote


Subject Written By Posted
MySQL fails to start because of missing mysql.plugin table Pablo Rauzy 09/04/2010 05:31PM
Re: MySQL fails to start because of missing mysql.plugin table Pablo Rauzy 09/05/2010 03:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.