How to solve the problem that MySQL can't start automatically

First, download the installation files

Find zip file at MySQL official website

Second, extract files, select location

It's best to put it on a certain disk in the MySQL folder, which is easier to find, where we extract the files to the D-Disk MySQL folder.

Third, let Windows know where your MySQL is

Create a My.ini file in the Windows Home directory of the system disk, which reads as follows:

[mysqld]basedir=d:/mysql/datadir=d:/mysql/data/

Then set the PATH environment variable. Add D:mysqlbin, so that the next time you enter the command mode, you can use MySQL directly, without first moving to the D-disk Mysql/bin directory.

Four, let Windows services to join MySQL

It means that when Windows starts, MySQL can start automatically.

In command line (CMD) mode, go to the Mysql/bin directory in the D disk, and then enter

Mysqld-nt-install

If it goes well, you will be prompted:

Server successfully installed.

Reboot the computer, install complete

After reboot, go to "Control Panel"-"service" to see if the MySQL service is displayed as "Start".

If you don't want MySQL to start the computer every time it starts directly, you can change the automatic to manual.