Aller au contenu
Infogérance Linux Debian en France

Infogérance Linux Debian en France

Kogitae : Ingéniérie de l'hébergement Internet

  • Accueil
  • Parcours
  • Presse
  • Portfolio
  • Blog

MySQL: “Table ‘mysql.plugin’ doesn’t exist” after MySQL Upgrade ~ Mattias Geniar

  • Accueil » Blog » MySQL: “Table ‘mysql.plugin’ doesn’t exist” after MySQL Upgrade ~ Mattias Geniar
DansCentos

MySQL: “Table ‘mysql.plugin’ doesn’t exist” after MySQL Upgrade ~ Mattias Geniar

MySQL: “Table ‘mysql.plugin’ doesn’t exist” after MySQL Upgrade

Posted on Wednesday, December 1, 2010 by Matti

After running a MySQL upgrade, you can run into the following problem which prevents you from starting MySQL successfully.

101126 10:29:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

101126 10:29:53 [Note] Plugin ‘ndbcluster’ is disabled.

/usr/libexec/mysqld: Table ‘mysql.plugin’ doesn’t exist

101126 10:29:53 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.

101126 10:29:53 InnoDB: Started; log sequence number 1 3337694676

101126 10:29:53 [ERROR] Can’t open and lock privilege tables: Table ‘mysql.servers’ doesn’t exist

101126 10:29:53 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50045, now running 50153. Please use mysql_upgrade to fix this error.

…

101126 10:29:41 InnoDB: Shutdown completed; log sequence number 1 3337694676

This is a real chicken and egg problem. To fix the problem, we need to run mysql_upgrade, but in order to run that command, MySQL needs to be functioning. And it won’t do that, until mysql_upgrade is run. Humpf.

It’s most commonly caused by an old my.cnf config file, which could be solved like this.

# cp /etc/my.cnf /etc/my.cnf_backup

# cp /etc/my.cnf.rpmnew /etc/my.cnf

# /etc/init.d/mysqld start

The reason is because in MySQL 5.0, a config variable named “skip-bdb” would exist in the my.cnf, which was removed in MySQL 5.1. Alternatively, you could comment out the “skip-bdb” parameter in the my.cnf, and try restarting MySQL. A bugreport has already been filed.

After which you need to run the mysql_upgrade.

# mysql_upgrade -u <user> -p

Alternatives to check, if the above does not work, is:

Are all files in /var/lib/mysql (or whatever your MySQL datadir is), owned by mysql?

Are there old logfiles in /var/lib/mysql named “ib_logfile0″ or “ib_logfile1″? If so; rename them, and try restarting MyS

viaMySQL: “Table ‘mysql.plugin’ doesn’t exist” after MySQL Upgrade ~ Mattias Geniar.

blog-administrateur-systeme can-open-mysql-plugin cant-open-and-lock-privilege-tables-table-mysql-servers-doesnt-exist-after-upgrade-5-1 cant-open-the-mysql-plugin-table-please-run-mysql_upgrade-to-create-it centos-6-yum-install-openssl debian-update-table-mysql-plugin-doesnt-exist error-cant-open-the-mysql-plugin-table-please-run-mysql_upg-rade-to-create-it error-cant-open-the-mysql-plugin-table-please-run-mysql_upgr-ade-to-create-it error-cant-open-the-mysql-plugin-table-please-run-mysql_upgrade-to-create-it freelance-linuxunix kogitae mysql_upgrade-debian mysql_upgrade-to-create-it mysql-plugin-doesnt-exist run-mysql_upgrade sudo-update-initramfs-u-ne-fonctionne-pas table-auth-administrateur-doesnt-exist table-mysql-plugin-doesnt-exist table-mysql-plugin-doesnt-exist-please-run-mysql_upgrade-to-create-it table-mysql-servers-doesnt-exist

Étiquettes

administrateur-systeme-freelance (9) amazon (3) apache (14) asterisk (9) auth (3) bash (6) blog-administrateur-systeme (14) blog-administration-systeme (4) collectd (5) cpu (3) debian (30) dovecot (4) duplicate (3) f (6) freelance-asterisk (3) google (3) infogerance-linux (5) infogérance (4) ipv6 (7) kernel (4) kogitae (30) kogitae-com (3) kogitae-fr (6) lamp-or-linux-or-developpement-web-and-apache-or-php-or-mysql-or-adobe-or-eclipse-or-zend-or-mozilla-or-firefox (17) lenny (4) lighttpd (5) limit (4) linux (26) mail (7) mdadm (6) mysql (14) openvz (9) optimiser (4) php (5) postfix (11) privvmpages-openvz (3) pxe (3) raid (3) SEO (5) ssh (8) ssl (3) test (3) voip (4) wordpress (6) www-kogitae-fr (7)