MySQL 5.7.17 zip installation and configuration tutorial Solution to MySQL startup failure

MySQL 5.7.17, now seems to be the latest version, download address

Here you can choose your own platform version and choose your own download. Mine is the Windows version. It should be similar.

Here I will talk about the ZIP version of the downloaded file. I haven’t tried the MIS version and I don’t know.
I would like to remind you here that it is best to download the version without debug , because I downloaded it once and the installation failed in the end because there was no ini file, which caused many problems.

After decompression is complete, just put it on a created file.

The decompressed file has a default configuration file (my-default.ini). Create a new file in the decompressed path: my.ini (copy the my-default.ini file and modify it above), copy the following code into it. F:\mysql appears twice in the code. This is the decompression path of my MySQL. You can replace it according to your own path.

[mysql]
# Set the default character set of the mysql client to default-character-set=utf8 
[mysqld]
#Set port 3306 port = 3306 
# Set the installation directory of mysql basedir="F:\mysql"
# Set the storage directory of mysql database data datadir="F:\mysql\data"
# Maximum number of connections allowed max_connections=200
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB

Run the command prompt as an administrator (right-click the icon in the lower left corner, I forgot what it is called, there is a command prompt as an administrator, you must use this, don’t just press the "what+R" button), switch to the MySQL bin directory, enter the mysqld install command (note that it is mysqld, not mysql) , and press Enter to install MySQL, as shown in the figure below: Here, because I have already downloaded and installed it, it shows that the service already exists. Yours should show that the service was created successfully.

The installation is now complete, and we have one last step to run it.

Type net start mysql to start MySQL, and type net stop mysql to shut down the MySQL service . Still the same question, mine has been completed, yours should say "starting" or "started successfully".

Configure the environment variables here. The locations of environment variables in different Windows versions are slightly different. They are roughly in System and Security-System-Advanced System Settings-Environment Variables. We find an environment variable for path here, click Edit, then click Edit Text, and add the path of your MySQL bin under its path; remember to add ";" after each path segment.

Some people may encounter some problems here, and unfortunately I also encountered it. Some people may encounter a problem of startup failure.

Solution: After installing MySQL, open the cmd command window and enter the bin directory in the MySQL installation directory, then enter the following command and press Enter: mysqld –initialize-insecure –user=mysql

After executing the above command, MySQL will create a data folder and a default database. The login username is root and the password is blank. Then you can start the MySQL service through the command net start mysql.

After that, I just did it myself. But it is under cmd. Not a graphical interface. Two better graphical interfaces are workbench and sqlyog developed by MySQL itself. There is a tutorial for installing workbench later.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.