windows - Can't open the mysql.plugin table. Please run mysql_upgrade to create it

Question

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:AppsMySQLmysql-5.7.17-winx64
datadir = D:AppsMySQLdata5717

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.

Answer 1

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

binmysqld --initialize

or

binmysqld --initialize-insecure

The latter will set an empty root password.