MySQL 5.7.20 Green Edition installation detailed graphic tutorial,

MySQL 5.7.20 Green Edition installation detailed graphic tutorial,

What is MySQL first?

MySQL is a relational database management system developed by MySQL AB in Sweden. It is currently a product of Oracle. It is a relational database management system. The SQL language used is the most commonly used standardized language for accessing databases. MySQL adopts the dual Authorization Policy, which is divided into community edition and commercial edition. because of its small size, fast speed, and low total cost of ownership, especially open source code, generally, MySQL is used as the website database for the development of small and medium websites.

The following article hasMySQL Community Server 5.7.20For example, we will introducemysql-5.7.20-winx64.zipThe installation details of the green version are as follows: the installation version of mysql-5.7.20-winx64.zip is free. : Https://dev.mysql.com/downloads/mysql/

After the download is complete, decompress the package to the specified storage location.mysql-5.7.20-winx64, (Suwen house blog xiaobian to mysql-5.7.20-winx64 directory to mysql-5.7.20, to facilitate the same name), the specific directory structure is as follows:

mysql-5.7.20 +bin +docs +include +lib +share COPYING README

After decompression, the data folder and my. ini configuration files do not exist. These files must be manually generated.

1. Configure environment variables. This document uses win10 as an example to open the system variables and configure mysql environment variables. The specific parameters are as follows:

Mysql_Home=D:\Program Files (x86)\mysql-5.7.20path=...;%Mysql_Home%\bin;

Note: Add % Mysql_Home % \ bin in Path. To add new content, do not move the original content ("..." Here indicates the original content). Save the content.

2. generate the data folder required by the mysql server, in the D: \ Program Files (x86) \ mysql-5.7.20 \ bin directory with the Administrator permission to open cmd (win10 as an example, in the lower-left input box, Enter cmd, right-click cmd, and open it with the Administrator), and execute the following commands in sequence:

C:\Users\wang>d:D:\>cd D:\Program Files (x86)\mysql-5.7.20\binD:\Program Files (x86)\mysql-5.7.20\bin>mysqld --initialize-insecure --user=mysql

After the execution is complete, the returned directory will find more data folders.

3, in D: \ Program Files (x86) \ mysql-5.7.20 directory, create a new my. ini file, the content is as follows (can be found online, basically similar ):

[Client] port = 3306default-character-set = utf8 [mysqld] # Set MYSQL installation directory basedir = D: \ Program Files (x86) \ mysql-5.7.20 # Set mysql data directory datadir = D: \ Program Files (x86) \ mysql-5.7.20 \ dataport = 3306character_set_server = utf8sql_mode = NO_ENGINE_SUBSTITUTION, NO_AUTO_CREATE_USER # enable query cache tasks = trueskip-grant-tables

After completing steps 2 and 3, run cmd with administrator privileges to switch to the D: \ Program Files (x86) \ mysql-5.7.20 \ bin directory, runmysqld -installCommand.Service successfully installedIndicates that the registration is successful. Reference

4. Run cmd with administrator privileges to switch to the D: \ Program Files (x86) \ mysql-5.7.20 \ bin directory and run the start or stop command.

Start commandnet start mysql

Stop commandnet stop mysql

Summary

The above is a detailed graphic tutorial on installing MySQL 5.7.20 Green Edition. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!