Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

mysqld: Table 'mysql.plugin' doesn't exist MESSAGE in Error log. When i do a desc on it, it is there

LewisLL12257Aug 16 2019 — edited Aug 19 2019

How do I resolve this message in the error log?

When i issue the mysqld.exe --validate -config

In the error log I see the following message.

But when I login into the db and issue the desc mysql.plugin, the table exists.

mysqld: Table 'mysql.plugin' doesn't exist

2019-08-16T18:25:46.675762Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

2019-08-16T18:25:46.676248Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\MySQL\MySQLaux\MySQL Server\data\ib_buffer_pool

2019-08-16T18:25:46.676550Z 0 [ERROR] unknown option '--validate-config'

2019-08-16T18:25:46.677474Z 0 [ERROR] Aborting

The desc on mysql.plugin, it returns the table definition and is clearly there.

mysql> desc mysql.plugin;

+-------+--------------+------+-----+---------+-------+

| Field | Type         | Null | Key | Default | Extra |

+-------+--------------+------+-----+---------+-------+

| name  | varchar(64)  | NO   | PRI |         |       |

| dl    | varchar(128) | NO   |     |         |       |

+-------+--------------+------+-----+---------+-------+

2 rows in set (0.00 sec)

Comments
Post Details
Added on Aug 16 2019
1 comment
9,676 views