run mysql upgrade,无法打开mysql.plugin表。请运行mysql_upgrade创建它

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

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.

解决方案

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.