When installing MySQL5.7.18winX64 in Win10, the server fails to be started and no error message is displayed. mysql5.7.17winx64

When installing MySQL5.7.18winX64 in Win10, the server fails to be started and no error message is displayed. mysql5.7.17winx64

System Environment: Win10 64-bit

MySQL version: mysql-5.7.18-winX64

The deployment steps are as follows:

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

2: I copied my. ini (It's my-default.in, my. ini is renamed after the file is copied, it should be OK), paste it to the installation directory D: \ Program Files \ MySQL Server 5.7 of 5.7, and modified the following two sentences:

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

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

3: The Administrator (win10, always need this permission) runs cmd (find it in system32 of windows), input: mysqld-install, and the installation is successful. Then enter:. net start mysql.

In this case, you can see five files in the data folder and open the file suffixed with. err. The prompt is: 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 enter mysqld -- initialize -- user = mysql -- console to execute this command to generate the database. Note that there is a temporary password. Remember to write it down;

3. start the Service net start mysql;

4. Run the mysql command: mysql-uroot-p and enter the password;

5. enter set password = password ('root') to change the root logon password. // The root here is the new password.