无法打开mysql.plugin表.请运行mysql_upgrade创建它 [英] Can't open the mysql.plugin table. Please run mysql_upgrade to create it

问题描述

我已经从此处 https://dev.mysql.com/下载了mysql ZIP. downloads/file/?id = 467269

然后解压缩它，将my-default.ini重命名为my.ini，设置

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

然后开始

mysqld --console

在管理员权限下.此处描述了所有内容: http://dev.mysql. com/doc/refman/5.7/en/windows-install-archive.html

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:

[错误]无法打开mysql.plugin表.请运行mysql_upgrade到 创建它.

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

并且不起作用.

推荐答案

您可能误会了列表初始化MySQL 中的第4点.这意味着要在其中复制现有数据目录或创建一个新目录，请参见

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

或

bin\mysqld --initialize-insecure

后者将设置一个空的root密码.

The latter will set an empty root password.

这篇关于无法打开mysql.plugin表.请运行mysql_upgrade创建它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！