This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,831 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

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

LewisLL12257
LewisLL12257 Member Posts: 3
edited Aug 19, 2019 9:53AM in MySQL Community Space

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)

Answers

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 374 Employee
    edited Aug 19, 2019 9:53AM

    It looks like your did not run mysql_upgrade after installing a new version of MySQL.  Just as the message is telling you.

    The MySQL mysql tables get changed and updated from release to release and you need to run mysql-upgrade (at least up to 8.0.17 where the work is done automatically for you) to reflect the changes and the additional updates.

    Dave Stokes

    MySQL Community Manager