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

Created:

2016-11-16 13:20:48 UTC

Modified:

2017-08-17 18:50:32 UTC

2

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

Missing/corrupted mysql.plugin table.

Resolution

  1. Open Terminal and go to /var/lib/mysql/mysql/ folder:
    # cd /var/lib/mysql/mysql/
  2. Download and unpack missing plugin table:
    # wget https://support.plesk.com/hc/en-us/article_attachments/115000459433/plugin.tar
    # tar zxvf plugin.tar
  3. Set correct permissions:
    # chown mysql.mysql /var/lib/mysql/mysql/plugin*
  4. Start MySQL service.

Attachments:

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