Win10 installation MySQL fails to start the server without error prompt

System environment: Win10 64-bit

MySQL version: mysql-5.7.18-winX64

The deployment steps are as stated on the Internet:

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

2: Copy my.ini in the installation directory of an old version of mysql (online Say this is my-default.in. My my.ini is copied and renamed after this file. It should be OK) , paste it into the 5.7 installation directory D:\Program Files\MySQL\MySQL Server 5.7, and modified 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 in the installation directory D:\Program Files\MySQL\MySQL Server 5.7 Folder;

3: Administrator (the damn win10 always requires this permission) Run cmd (Go to Windows system32 to find ), enter: mysqld -install, it shows that the installation is successful; then enter: net start mysql, it prompts that the service failed to start.

At this time: go to the data folder and see 5 files, open the file with the suffix .err, and there is a prompt: Table 'mysql.plugin' doesn't '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 and generate the library. Note that there is a temporary password, which should be written down;

3. Start the service net start mysql;

4. Enter the mysql command: mysql -uroot -p, enter the password just now;

5. Then enter set password = password('root') to modify the root login password; //root here is the new password

I solved it according to the blogger's method Installation issues with this version.

The above is the detailed content of Win10 installation MySQL fails to start the server without error prompt. For more information, please follow other related articles on the PHP Chinese website!