Install and configure MySQL5.7 and MySQL5.7

Install and configure MySQL5.7 and MySQL5.7

 

1. Double-click to install, such:

2. 2

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

3. 3

   Follow the steps 1 and 2 to go:

4. 4

   Go to the settings page, such:

5. 5

   In the old version, three installation types are available: Typical (Typical installation), Complete (full installation), and Custom (Custom installation ).

   Typical (Typical installation) Only installs MySQL server, mysql command line client, and command line utility. The command line client and utility include mysqldump, myisamchk, and several other tools to help you manage your MySQL server.

   Complete installation installs 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 (Custom installation) Installation allows you to have full control over the packages and installation paths you want to install.

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

    

6. 6

   Verify the environment before installation, such:

7. 7

   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:

8. 8

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

    

9. 9

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

10.  

    Next, for example:

11.  

    Go to the server Configuration page and select three server types. Which server will affect the memory, hard disk, and process or usage decisions of the MySQL Configuration Wizard.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 the 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.

    For example:

12.  

    Click "Next" to enter:

13.  

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

     

14.  

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

15.  

    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,

     

16.  

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

17.  

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

     

18.  

    Or use MySQL Workbench, for example:

19.  

    Enter the password and query it, for example:

20.