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

This article mainly introduces how to install and configure MySQL 5.7.21 decompression version, which has certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let Xiaobian take you to understand it together.

1. First, you need to download MySQL decompression version, download address: https://www.mysql.com/downloads/, illustration:

2. Unzip the installation package and choose the path according to your preferences. The path I chose is C:\software\, so the complete path of MySQL is: C:\software\mysql-5.7.21-winx64

3. Configure environment variables

Added system environment variables:

Key Name: MYSQL_HOME

The value is: C:\software\mysql-5.7.21-winx64

Add: %MYSQL_HOME%\bin to Path, note that the ";" symbol between different values in Path cannot be omitted

4. Prepare my.ini file, you can first create a new my.txt file, and then rename the file suffix to.ini, the previous version may exist after decompression my-default.ini file, but version 5.7.21 does not, so you have to manually create the file, the contents of the file are as follows:

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

Note: The installation path of MySQL is in the red box, and "/" instead of "\" is used between folders, otherwise errors may occur in the following operations.

After editing the my.ini file, place the my.ini file under C:\software\mysql-5.7.21-winx64

5. Open cmd command window as administrator and switch directory to bin directory of MySQL installation directory

6. Execute the following statement to install MySQL

mysqld -install

Service successfully installed. Indicates successful installation

7. Execute the following statement to initialize MySQL

mysqld --initialize-insecure --user=mysql

Executing the command will generate the data directory in MySQL's installation directory and create the root user.

8. Execute the following command to start the mysql service

net start mysql

After execution, there will be the following prompt:

MySQL service is starting..

MySQL service started successfully.

9. After MySQL is started, the root user password is empty, set the password, the command is as follows:

mysqladmin -u root -p password New password Enter password: Old password

When you need to enter the old password, because the old password is empty, you can enter it directly.

Thank you for reading this article carefully. I hope that the article "How to install and configure MySQL 5.7.21 decompression version" shared by Xiaobian will be helpful to everyone. At the same time, I hope that everyone will support it more, pay attention to the industry information channel, and more relevant knowledge is waiting for you to learn!

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.