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

This article will explain in detail how to install MySQL 5.7.23 decompression version, Xiaobian think it is very practical, so share it with you as a reference, I hope you can gain something after reading this article.

Download URL

https://dev.mysql.com/downloads/mysql/

The detailed illustration is as follows:

1. According to your own needs, choose the one that suits you to download.

2. Unzip the installation package to your favorite path, I chose the path D:\Program Files\

3. Configure environment variables

I am Windows 10 system, find the environment variable configuration location

Add environmental system variables

MYSQL_HOME

D:\Program Files\mysql-5.7.23-winx64

Edit path variable and add MYSQL_HOME

4. Create a new my.ini file. Version 5.7 does not have this file. You need to create it yourself. The contents are as follows. Note that you need to modify your own file address.

[mysqld]port = 3306basedir=D:/Program Files/mysql-5.7.23-winx64datadir=D:/Program Files/mysql-5.7.23-winx64/data max_connections=200character-set-server=utf8default-storage-engine=INNODBsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES[mysql]default-character-set=utf8

Place the my.ini file in D:\Program Files\mysql-5.7.23-winx64.

5.cmd Open the command window and switch to MySQL directory.

6. Execute mysqld -install to install

7. Execute mysqld --initialize-insecure --user=mysql command initialization

When successful, the data directory is generated and the root user is generated.

8. Run net start mysql to start MySQL.

9. Start successfully, execute "mysqladmin -u root -p password new password" command to set password, root old password is empty, just enter.

The unzipped version is now installed.

About "how to install MySQL 5.7.23 decompression version" this article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it to let more people 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.