Solution to the problem "Table mysql.plugin doesn't exist" when deploying MySQL

Today I deployed the free-installation version of MySQL, and the problem of Table 'mysql.plugin' doesn't exist occurred. After a long time of trouble, I finally found a solution online. Now I will share it with you:

System environment: Win10 64-bit

MySQL version: mysql-5.7.17-winX64

The deployment steps are as described online:

1: Modify the environment variable path and increase the value C:\Program Files\mysql-5.7.17-winX64\bin

2: Modify my-default.ini, rename it to my.ini, and modify the file content:

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

Create an empty data folder in the main directory "C:\Program Files\mysql-5.7.17-winX64";

3: The administrator runs cmd and enters: mysqld -install, which shows that the installation is successful; then enter: net start mysql, which prompts that the service startup failed.

At this point: Go to the data folder and see 5 files. Open the file with the suffix .err, which prompts: Table 'mysql.plugin' doesn't exist

The solution to this problem is:

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

2. Go to the \bin directory in cmd, and then enter mysqld --initialize --user=mysql --console to execute this command to generate the database. Note that there is a temporary password, so write it 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 root login password;

I succeeded by following this operation, I hope it can be helpful to you.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.