Dims Dims - 9 months ago 126
MySQL Question

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

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.

Answer Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download