In windows, MySQL 5.7.3.0 installation and configuration graphic tutorial (installation version), mysql5.7.3.0

In windows, MySQL 5.7.3.0 installation and configuration graphic tutorial (installation version), mysql5.7.3.0

First, the MySQL official website downloads the mysqlserver installation software package from http://dev.mysql.com/downloads/.

Mysql-installer-community-5.7.3.0-m13.msi "not much said, double-click to enter the installation.

For example:

Click "Install MySQL Products" in the red box to go to the installation page, for example:

Follow the steps 1 and 2 to go:

Go to the settings page, such:

In the old version, there are three installation types: Typical ( Typical installation), Complete (full installation)And Custom ( Customized installation).

Typical (Typical installation)Only the MySQL server,MysqlCommand Line client and command line utility. The command line client and utility includeMysqldump, MyisamchkAnd several other tools to help you manage your MySQL server.

Complete (Full installation)Install all components included in the package. Components included in the fully-installed software package include the Embedded Server library, benchmarking suite, supporting scripts, and documentation.

Custom (Customized installation)Installation allows you to have full control over the packages you want to install and the installation path.

In the new version, the options are different, but I chose the first option by default. For other options, see:

Verify the environment before installation, such:

After you click the "Execute" button, you may download some programs. Then you can click Install On Your Own until all the installation is complete. For example:

Click "Next" to go to the installation page, for example:

The network is not good. It may take a while. Wait! When the installation is complete, such:

Next, for example:

Enter the server configuration, such:

You can select three server types, which of the following will affect MySQL Configuration Wizard's decision on memory, hard disk, and process or usage.

· Developer Machine: This option represents a typical personal desktop workstation. Assume that multiple desktop applications are running on the machine. Configure the MySQL server to use the least amount of system resources.

· Server Machine (Server): This option indicates the Server. The MySQL Server can run with other applications, such as FTP, email, and web servers. Configure the MySQL server to use the appropriate proportion of system resources.

· Dedicated MySQL Server Machine (Dedicated MySQL Server): This option indicates a Server that only runs the MySQL service. It is assumed that no other application is running. The MySQL server is configured to use all available system resources.

Click "Next" to enter:

Click "Next" to enter the Myqsl configuration of the system service, for example:

Click "Next" to go to the log configuration page, for example:

I simply configure the path for storing error logs. If you do not want to enter the log configuration, do not select the advanced configuration in "server configuration,

After logging configuration, click "Next" to enter the final configuration, as shown in the following figure:

After the MySQL installation is complete, let's verify if it can be used normally, for example:

Or use MySQL Workbench, for example:

Enter the password and query it, for example:

Complete all installation configurations.

References: https://dev.mysql.com/doc/refman/5.1/zh/installing.html#windows-using-installer