Detailed tutorial for installing mysql5.7.21 under Windows system

MySQL Installer provides an easy-to-use, wizard-based installation experience for all your MySQL software needs. The product contains the latest versions of:

MySQL Server

MySQL Connector

MySQL Workbench and Example Models

Sample Database

MySQL for Excel

MySQL Notifier

MySQL for Visual Studio

document

Tools/Materials: mysql-installer-community-5.7.21.0.msi Link: https://pan.baidu.com/s/1nxmngff Password: g4si

Method/Steps:

1. Search Baidu for MySQL official website download

mysql-installer-web-community online installation

mysql-installer-community local installation

Note: The MySQL installer is 32-bit, but will install both 32-bit and 64-bit binaries.

2. Online installation: Windows (x86, 32-bit), MSI Installer5.7.21

Open and run: mysql-installer-community-5.7.21.0.msi

Check I accept and click next

3. Select the installation method, Choosing a Setup Type Here, select the default installation method first Development, click Next (if you only need MySQL as the database server, select the second Server Only, and select the fourth Full for all installations)

4. Test environment: click execute

5. If something is missing, a pop-up window will pop up automatically to install it. Click to accept and install it.

6. After installation, skip the installation environment here. The two in the list are not needed. Click Yes.

You need to install it manually

7. Click execute to perform the installation

8. The status shows complete, click next

9. Software configuration, click next

10. Default option, click next

The second one is just for testing

11. Enter the root account password

12. Check whether the port is occupied

netstat -ano | findstr "3306"

13. Windows service default, click next

14. MySQL 5.7.21 adds new protocol support, which is implemented through X Plugin. It also adds a new client API. Developers can use the API to use MySQL as the document store server and perform document operations similar to MongoDB, such as supporting CRUD operations. However, the underlying storage still supports the ACID of traditional databases, and the operations themselves are also expanded to standard SQL at the bottom layer. Judging from the current MySQL, the boundary between NOSQL and traditional databases is getting smaller and smaller. Currently this feature is not Production Ready and is recommended only for testing environments.

Optional.

15. Apply the configuration and click execute

16. Application configuration is complete, click finish

17. Connect to the server, enter the root password, and click check

Test success

18. Installation completed

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.6 installation tutorials for various versions

MySQL 5.7 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.