Mysql 5.7.18 decompressed version installation and startup instance method

This article mainly introduces Mysql 5.7.18 decompressed version downloadInstallation and detailed graphic explanation of starting the mysql service. It is very good and has reference value. Friends who need it can For reference

Because there is no .ini file in the distribution package of MySQL Community Server5.7.18, and the data directory will not be initialized, the installation and configuration tutorials for previous versions on the Internet are not applicable

step1: Download from the official websitedev.mysql.com/downloads/mysql/

After decompression

step2: now configure the environment Variables

Create a new system variable named MYSQL_HOME, and the path is the decompressed file path ( Remember to go to bin)

Add;%MYSQL_HOME%\bin to the path

step3 : Go to C:\Windows\System32\cmd.exe, select cmd.exe and run it as administrator

cd to the file path, such as D:\ SQL server\MySQL\mysql-5.7.18-winx64\bin

##Enter mysqld –initialize-insecure to generate the data directory

Because there is no .ini file, you can use mysqld –verbose –help to view the configuration (you can do this without executing this command)

Enter mysqld -install to load the service (because I installed it again, , so the result is different from the first installation, hhhh)

Enter net start mysql to start the service

Enter mysql -u root -p to initialize without a password, and press Enter to enter the database directly

1. There is a Chinese manul, but it is a transfer of version 5.1

tool.oschina.net/apidocs/apidoc?api=mysql-5.1-zh

2. The 5.7 version manul on the official website has Tutorial in English, and Chinese can be downloaded on csdn, but I don’t have enough coins to download, it’s okay, I can hold it in English, I need to transfer it

dev.mysql.com/doc/refman/5.7/en/tutorial.html

【Related Recommended】

1.

Free mysql online video tutorial

2.

MySQL latest manual tutorial

3.

Things about database design

The above is the detailed content of Mysql 5.7.18 decompressed version installation and startup instance method. For more information, please follow other related articles on the PHP Chinese website!