[SOLVED] Can't open the mysql.plugin table. Please run mysql_upgrade to create it

Issue

I have downloaded mysql ZIP from here https://dev.mysql.com/downloads/file/?id=467269

Then extracted it, renamed my-default.ini to my.ini, set

basedir = D:\Apps\MySQL\mysql-5.7.17-winx64
datadir = D:\Apps\MySQL\data5717

then started

mysqld --console

under admin privileges. All was described here: http://dev.mysql.com/doc/refman/5.7/en/windows-install-archive.html

Unfortunately it prints the following in console:

[ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to
create it.

and doesn’t work.

Solution

You probably misunderstood/skipped point 4 in your list, Initialize MySQL. It means to either copy an existing data directory there or to create a new one, see Initializing the Data Directory Manually Using mysqld .

To initialize a fresh data directory, you basically (after setting your config file) just have to run either

bin\mysqld --initialize

or

bin\mysqld --initialize-insecure

The latter will set an empty root password.

Answered By – Solarflare

Answer Checked By – David Goodson (BugsFixing Volunteer)

Leave a Reply

Your email address will not be published. Required fields are marked *