Win10 installation MySQL-5.7.18-winX64 startup server failed and no error prompt, mysql5.7.17winx64

Win10 installation MySQL-5.7.18-winX64 startup server failed and no error prompt, 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: copyMy. ini), Paste it to the 5.7 installation directoryD: \ Program Files \ MySQL Server 5.7And modified the following two sentences:

Basedir = D:/Program Files/MySQL Server 5.7
Datadir = D:/Program Files/MySQL Server 5.7/data

In the installation directoryD: \ Program Files \ MySQL Server 5.7Create an emptyDataFolder;

3:Administrator (this permission is always required for win10)Run cmd (Go to system32 in windows and find), Enter:Mysqld-install, Indicating that the installation is successful. Then enter:Net start mysql, Prompting that the service cannot be started.

At this point:DataFive files are displayed in the folder, and the suffix is. ErrFile, 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 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.

According to this method of Boyou, I solved the installation problem of this version.

This solution is my reference Boyou: http://www.cnblogs.com/Catherine2011/p/6543725.html