MySQL deployment prompts Table mysql. plugin doesn 't exist solution

  • 2021-08-12 03:51:58
  • OfStack

Today, the installation-free version of MySQL was deployed, and the problem of Table 'mysql. plugin' doesn 't exist appeared. After a long time of distress, I finally found a solution on the Internet. Now I will sort it out and share it with you:

System environment: Win10 64-bit

MySQL version: mysql-5. 7.17-winX64

The deployment steps are as described on the Internet:

1: Modify the environmental variable path and add value C:\ Program Files\ mysql-5. 7.17-winX64\ bin

2: Modify my-default. ini, rename my. ini, modify file contents:


# basedir = C:\Program Files\mysql-5.7.17-winX64
# datadir = C:\Program Files\mysql-5.7.17-winX64\data

Create an empty data folder under the home directory "C:\ Program Files\ mysql-5. 7.17-winX64";

3: The administrator runs cmd, and inputs: mysqld-install to show that the installation is successful; Re-enter: net start mysql, indicating that the service failed to start,

At this time: See 5 files under the data folder, open the file with the suffix. err, and prompt: Table 'mysql. plugin' doesn 't exist

The solution to this problem is:

1. Copy my. ini to the\ bin folder;

2. Execute this command in the cmd to\ bin directory, and then type mysqld-initialize-user=mysql-console to generate the library. Note that there is a temporary password, which should be written down;

3. Start the service net start mysql;

4. Enter the mysql command: mysql-uroot-p, and enter the password just now;

5. Enter set password = password ('root') to change the login password of root;

I have succeeded in following this operation, hoping to be helpful to you.


Related articles: