Win10 installation of MySQL5.7.18winX64 failed to start the server and no error message

System environment: Win10 64-bit

MySQL version: mysql-5.7.18-winX64

The deployment steps are as described online:

1: Modify the environment variable path and increase the value D:\Program Files\MySQL\MySQL Server 5.7\bin

2: Copy the my.ini file from the old version of MySQL installation directory (the Internet says it is my-default.in. My my.ini file is renamed after copying this file. It should be OK). Paste it into the 5.7 installation directory D:\Program Files\MySQL\MySQL Server 5.7, and modify the following two sentences:

basedir = D:/Program Files/MySQL/MySQL Server 5.7
datadir = D:/Program Files/MySQL/MySQL Server 5.7/data

Create an empty data folder in the installation directory D:\Program Files\MySQL\MySQL Server 5.7;

3: The administrator (annoying win10 always requires this permission) runs cmd (find it in system32 of windows), enters: mysqld -install, and it shows that the installation is successful; then enter: net start mysql, and it 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, enter the password just now;

5. Enter set password = password('root') to change the root login password; //Here root is the new password