Mysql service shows: Table 'mysql.plugin' doesn't exist

Created:

2016-11-16 13:20:48 UTC

Modified:

2017-04-24 11:03:21 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Mysql service shows: Table 'mysql.plugin' doesn't exist

Applicable to:

  • Plesk for Linux

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

MySQL was upgraded but mysql_upgrade was not executed.

Resolution

Run the following command to create the missing table:

# mysql_upgrade -uadmin -p

Have more questions? Submit a request
Please sign in to leave a comment.