Shulou(Shulou.com)05/31 Report--

This article is about how to install and configure the green version of MySQL 5.7.20. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

First of all, what is MySQL?

MySQL is a relational database management system developed by the Swedish company MySQL AB and currently belongs to the products of Oracle. It is a relational database management system, and the SQL language is the most commonly used standardized language for accessing databases. MySQL software adopts the dual licensing policy, which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, especially open source, the development of small and medium-sized websites generally choose MySQL as the website database.

The following article has MySQL Community Server 5.7.20 as an example, mainly describes the detailed picture and text steps of mysql-5.7.20-winx64.zip green version installation, note that the download mysql-5.7.20-winx64.zip version is installation-free version. Download address: https://dev.mysql.com/downloads/mysql/

After the download is completed, extract it to the specified storage location. After the decompression, the file directory is mysql-5.7.20-winx64. (the editor of Suwenzhai blog changed the 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

There are no data folders and my.ini configuration files after decompression, which need to be generated by manual configuration.

1. Configure environment variables. Take win10 as an example, 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; to Path as a new content, leaving the original content unchanged ("..." Here represents the original content), and finally save it.

2. Generate the data folder required by the mysql server, and open the cmd with administrator permissions in the D:\ Program Files (x86)\ mysql-5.7.20\ bin directory (win10 as an example, enter cmd in the input box at the lower left corner, select cmd and right-click to open it with the administrator), and execute the following commands:

C:\ Users\ wang > 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 return directory will find that there are more data folders.

3. In the D:\ Program Files (x86)\ mysql-5.7.20 directory, create a new my.ini file with the following contents (which can be found on the Internet, 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 explicit_defaults_for_timestamp=trueskip-grant-tables

After completing steps 2 and 3, run cmd with administrator privileges to change to the D:\ Program Files (x86)\ mysql-5.7.20\ bin directory, execute the mysqld-install command, and Service successfully installed indicates that the registration is successful. Refer to the figure as shown below:

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

Start the command net start mysql

Stop the command net stop mysql

Thank you for reading! This is the end of this article on "how to install and configure MySQL 5.7.20 Green version". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.