Mysql service does not start with "Table 'mysql.plugin' doesn't exist" error

Refers to:

  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:20:48 UTC

Modified:

2017-02-25 10:23:42 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Mysql service does not start with "Table 'mysql.plugin' doesn't exist" error

Symptoms

Mysql service does not start. After enabling mysql error log following messages appear in it :

# /etc/init.d/mysql start
# tail /var/log/mysqld.error.log
140203 11:54:15 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
140203 11:54:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140203 11:54:15 InnoDB: Initializing buffer pool, size = 8.0M
140203 11:54:15 InnoDB: Completed initialization of buffer pool
140203 11:54:15 InnoDB: Started; log sequence number 0 430703763
140203 11:54:15 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
140203 11:54:15 [ERROR] Aborting
140203 11:54:15 InnoDB: Starting shutdown...
140203 11:54:20 InnoDB: Shutdown completed; log sequence number 0 430703763
140203 11:54:20 [Note] /usr/sbin/mysqld: Shutdown complete

Cause

/etc/my.cnf configuration file is corrupted.

Resolution

Either take proper configuration file from the backup file at /etc/ or download sample one from here and replace.

# mv /etc/my.cnf /etc/my.cnf.orig
# cp /etc/my.cnf.dpkg-dist /etc/my.cnf
# /etc/init.d/mysql start

Note: to enable mysql error log, add following line to /etc/my.cnf at [mysqld] section:

log-error = /var/log/mysqld.error.log

then run following commands to create the log file and assign permissions and ownership

# touch /var/log/mysqld.error.log
# chown mysql:mysql /var/log/mysqld.error.log
# chmod 644 /var/log/mysqld.error.log
Have more questions? Submit a request
Please sign in to leave a comment.