Win10 Installation of MySQL5.7. 18winX64 Server Startup Failed and No Error Prompt

System environment: Win10 64-bit

MySQL version: mysql-5. 7.18-winX64

The deployment steps are as described on the Internet:

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

2: Copy my. ini under the installation directory of an old version of mysql (it is said on the Internet that this is my-default. in, and my my. ini is renamed after copying this file, which should be OK), paste it into the installation directory of 5.7 D:\ Program Files\ MySQL\ MySQL 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 under the installation directory D:\ Program Files\ MySQL\ MySQL Server 5.7;

3: The administrator (win10 with egg pain, always need this permission) runs cmd (find it in system32 of windows), and inputs: mysqld-install, showing 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 mysql command: mysql-uroot-p, and enter the password just now;

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