MySQL installation and configuration tutorial (super detailed)

One 、 download MySQL

Mysql Official website download address ：MySQL :: Download MySQL Installer (Archived Versions)

1. Select the version to install , This article chooses 5.7.31 edition , Click on Download download

Uploading … Re upload cancel

Two 、 install MySQL

1. Select the setting type and double-click run mysql-installer-community-5.7.31.0.msi

Choose Custom installation here , So choose “Custom”, Click on “Next”

• “Developer Default” It is the developer's default
• “Server only” Install as a server only
• “Clientonly” Install only as a client
• “Full” Is a complete installation
• “Custom” It's a custom installation

  

  Uploading … Re upload cancel

2. Select the installed products and functions and click them in turn “MySQL Servers”、“MySQL Servers”、“MySQL Servers 5.7”、“MySQL Servers 5.7.31 -64”, Then click the green arrow to migrate the selected version to the right selection box

notes ： The choice here is 64 Bit system

3. Select first “MySQL Server 5.7.31” , Then click on the blue... Below “Advanced Options”

Uploading … Re upload cancel

4. Customize the installation path and data storage path , When the changes are complete, click “OK” notes ： Although installed in C There's nothing wrong with the disc , However, I personally recommend not to install to C disc , I installed it to D disc

5. Just click “OK” notes ： Here, because I chose the path I created myself , Therefore, the program prompts that the path already exists , Do you want to continue

6. When the changes are complete, click “Next”

Uploading … Re upload cancel

7. Make sure the installation path and data storage path are correct , If there is no problem, just click Next

8. Just click “Yes”

Uploading … Re upload cancel

9. Select first “MySQL Server5.7.31”, If there is no such environment in the computer , Installation will be prompted “Microsoft Visual C++ 2013” Environmental Science , Click on “Execute”

10. Click... After checking “Install”

11. installation is complete , Click on “Close”

Uploading … Re upload cancel

12. Seeing this check mark indicates that the environment is installed , Just click “Next”

Uploading … Re upload cancel

13. Just click “Execute”

14. This icon indicates that the installation is successful , Just click “Next”

15. Just click “Next”

Uploading … Re upload cancel

16. Just click “Next”

Uploading … Re upload cancel

17. Select the installation type for individual learning research “Development Computer” Then you can , My choice here is “Development Computer”

• Development Computer Suitable for personal development and learning
• Server Computer Is mainly used for things like FTP,email,web Servers and so on
• Dedicated Computer Only for MySQL The server

  

18. MySQL The default port is 3306, No modification is required , Just click “Next”

Uploading … Re upload cancel

19. You need to set MySQL Password , It doesn't need to be too complicated , After setting, click “Next”

Uploading … Re upload cancel

20. Just click “Next”

21. Just click “Execute”, Start installation , Wait a moment after clicking install

Uploading … Re upload cancel

22. Click on “Finish”

23. Click on “Next”

Uploading … Re upload cancel

24. Click on “Finish”, here MySQL installation is complete

Uploading … Re upload cancel

25. Search in the start interface mysql, Click on the first MySQL 5.7 Command Line Client

Uploading … Re upload cancel

26. Enter the MySQL Password , Press Enter key （ Enter key ）

Uploading … Re upload cancel

27. The following interface shows that the installation has been successful

thus ,MySQL Database installed successfully

3、 ... and 、 Configure environment variables

1. find MySQL Installation path for

Uploading … Re upload cancel

2. Right click this computer and select “ attribute ”

3. First click “ Advanced system setup ”, Click again “ environment variable ”

Uploading … Re upload cancel

4. stay “ System variables ” Choose from “Path”, Click on “ edit ”

Uploading … Re upload cancel

5. Click on “ newly build ”, take MySQL Add the installation path of , After clicking on “ determine ”

6. Just click “ determine ”

7. Verify that the environment variables are configured properly , Press down “window+R” key Pop up the run box , Input “cmd” Get into window Command line

Uploading … Re upload cancel

8. Input “mysql -u root -p” Press enter

9. Input password , Press down “Enter key （ Enter key ）”, When the following interface appears, the configuration is successful

Uploading … Re upload cancel

Summed up a lot about java Interview materials , I hope I can help you learn java Little buddy . Due to too much information, it is inconvenient to publish articles , It's not easy to create , I hope my friends can give me some motivation to continue to create better java Class learning material articles ,
Please support and pay more attention to the small work , Don't forget to like + Comment on + forward . I reply to the private message in the upper right corner 【999】 You can get free learning materials. Thank you ！
 

It's not easy to make , If it's helpful, I hope I can give you a recommendation and support , Thank you. .