![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342666279.jpg)
1. Download MySQL
This article chooses version 5.7.31
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342797540.jpg)
2. Install MySQL
1. Select the setting type
Double-click to run mysql-installer-community-5.7.31.0.msi. The choice here is custom installation, so directly select "Custom" and click "Next" ”
“Developer Default” is the developer default
“Server only” Installed only as a server
“Client only” Installed only as a client
"Full" is a complete installation
"Custom" is a custom installation
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342713120.jpg)
2. Select the products and features to install
Click on "MySQL Servers", "MySQL Servers", "MySQL Servers 5.7", "MySQL Servers 5.7.31 -64", and then click the green arrow to migrate the selected version to the right Select the box
Note: The 64-bit system selected here is
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342788494.jpg)
3. First select "MySQL Server 5.7.31" , then click the blue "Advanced Options" below
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342749121.jpg)
4. Customize the installation path and data storage path, and click "OK" after the changes are completed
Note: Although there is nothing wrong with installing on the C drive, I personally recommend not to install on the C drive. I installed it on the D drive
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342762603.jpg)
5. Click "OK" directly
Note: Because I selected the path I created myself, the program prompts that the path already exists. Do you want to continue?
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342768181.jpg)
6. After the changes are completed, click "Next"
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342880056.jpg)
7. Confirm that the installation path and data storage path are correct. , if there is no problem, just click Next
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342888397.jpg)
8. Click "Yes" directly
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342852915.jpg)
9. First select "MySQL Server5.7.31". If this environment does not exist on your computer, you will be prompted to install the "Microsoft Visual C 2013" environment. Click "Execute"
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342828147.jpg)
10. After selecting, click "Install"
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342845232.jpg)
11. When the installation is complete, click "Close"
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342870422.jpg)
12. When you see this check mark, it means that this environment is installed, just click "Next"
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342978255.jpg)
13. Click "Execute" directly
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342947862.jpg)
14. When this icon appears, the installation is successful. Click "Next" directly
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342974170.jpg)
15. Click "Next" directly
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342937901.jpg)
16. Click "Next" directly
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342937634.jpg)
17. Select the installation type
Personal If you want to study and research, you can choose "Development Computer". I choose "Development Computer" here
Development Computer is suitable for personal development and learning
Server Computer is mainly used for things like FTP, email, web server, etc.
Dedicated Computer is only used as a MySQL server
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342972540.jpg)
18. The default port of MySQL is 3306, which is not required To make changes, click "Next" directly
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526342998366.jpg)
19. Here you need to set the MySQL password, it doesn't need to be too complicated, just click "Next" after setting it
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343086028.jpg)
20. Click “Next” directly
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343069829.jpg)
##21 . Click "Execute" directly to start the installation. After clicking the installation, you need to wait for a while
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343075465.jpg)
22. Click “Finish”
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343077155.jpg)
23. Click “Next”
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343033750.jpg)
24. Click "Finish" and the MySQL installation is completed
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343067957.jpg)
25. Search for mysql on the start interface , click on the first MySQL 5.7 Command Line Client
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343065687.jpg)
26. Enter the MySQL password you just set and press the Enter key (Enter key)
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343158147.jpg)
27. When the following interface appears, it means the installation has been successful
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343140083.jpg)
##At this point, the MySQL database is installed successfully
3. Configure environment variables
1. Find the installation path of MySQL
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343164632.jpg)
2. Right-click this computer and select "Properties"
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343130814.jpg)
3. Click first "Advanced System Settings", then click "Environment Variables"
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343142836.jpg)
4. Select "Path" in "System Variables" and click "Edit"
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343146860.jpg)
5. Click "New", add the MySQL installation path, and then click "OK"
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343186326.jpg)
6. Click "OK" directly
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343288119.jpg)
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343229965.jpg)
##7 . Verify whether the environment variables are configured properly, press the "window R" key to pop up the run box, enter "cmd" to enter the window command line
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343222800.jpg)
8. Enter "mysql -u root -p" and press Enter
9. Enter the password and press the "Enter key (Enter key)". When the following interface appears, the configuration has been successful
![How to install and configure MySQL5.7.31](https://img.php.cn/upload/article/000/000/164/168526343224831.jpg)
The above is the detailed content of How to install and configure MySQL5.7.31. For more information, please follow other related articles on the PHP Chinese website!