MySQL 5.7.17 installation and configuration text tutorial, MySQL 5.7.17 text

MySQL 5.7.17 installation and configuration text tutorial, MySQL 5.7.17 text

Said the blogger: I recently wrote a blog post titled "The simplest MySQL tutorial in history". I suddenly thought that some of my shoes have never touched the MySQL database? The combination of theory and practice is king, so I have a blog post on MySQL database installation and configuration. To be honest, this blog post does not have any technical content. Let's give some reference to children's shoes that have never touched on the MySQL database!

First, download the MySQL database installation package: mysql-5.7.17.msi. Link: https://pan.baidu.com/s/1nuVVEEd password: 2fxw

After the download is complete, double-click to open the msi file and enter the following interface:

Note 1: Install all products required for MySQL databases; Note 2: servers that only use MySQL databases; Note 3: clients that only use MySQL databases; NOTE 4: install all products that contain the MySQL database. Note 5: manually select the product of the MySQL database to be installed.

Here, we only need to selectNote 2Server only, and then click Next to enter the following interface:

As shown in, this is the installation prompt page. Click Execute directly:

Note 1: indicates the current status; Note 2: indicates the current upgrade progress; Note 3: displays or hides the upgrade information.

As shown in, this interface displays the current status, progress, and upgrade information. When the upgrade Progress reaches100%As shown in:

As shown in, this is the mark of successful MySQL Database Upgrade. ClickNext:

As shown in, the system prompts that we have entered the product configuration stage. ClickNextYou can:

Note 1: Configure the server type; Note 2: select the TCP/IP protocol; Note 3: select the port number as 3306.

As shown in, select the default configuration and click Next:

As shown in, this interface is used to set accounts and roles. Here, we only need to setrootThe password of the Account (you must remember to verify the password when logging on to the MySQL database). The password must be at least four characters long. After setting the password, clickNext:

Note 1: because we are using the mysql-5.7.17 version, the default server name is MySQL57; Note 2: The default choice of Standard System Account.

As shown in, select the default configuration and click Next:

As shown in, this is the configuration of Plugins and Extension, that is, the configuration of plug-ins and extended applications, regardless of it, directly clickNextYou can:

As shown in, this interface enables us to confirm the server configuration that requires the application. After confirming that the configuration is correct, clickExecute:

As shown in, the server is being configured. In this case, if a prompt box is displayed on the computer, a prompt message such as "dangerous" is displayed. You do not need to worry about it. This is only because the security software will automatically trigger an alarm when you modify the configuration, click "agree.

As shown in, the server configuration is complete. Click Finish:

As shown in, the configuration is further displayed. ClickNext:

As shown in, here we have installed MySQL. Click Finish. If you want to view detailed MySQL installation logs, click Copy Log to Clipboard to Copy the logs to the text editor. Next, open the MySQL command line tool to verify that MySQL is successfully installed:

As shown in, it is clear that the installation is successful!

Tip:Here, we only installed the MySQL database server. for the client tool, Navicat for MySQL and DbVisualizer are recommended.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.