WIN10 System, Mysql-installer-community-5.7.19.0.msi installation

1. Go to the official website to find the installation package you need: https://dev.mysql.com/, path: Download-->mysql Community Edition (GRL)-->mysql on Windows ( Installer & Tool)

2. Locate the required installation package,

:

3. Click Download. The installation version (Mysql-install-community) is selected here

4. Choose not to log in to download.

5. Double-click to run the downloaded Mysql-installer-community-5.7.19.0.msi, the program will take some time to run, please wait a moment.

6. After successful operation, enter the Welcome interface. Select I agree to the agreement, or you will not be able to proceed to the next step.

7. Enter the type selection page, I need MySQL cloud service to select the developer default (7.1 is the default installation steps), if only want to install MySQL The server's choice of custom mode (7.2 steps is to choose the type of server you need, selected for doing some data analysis)

Developer Default (Developer defaults): Install all the products required for MySQL development

Server only (server): Install only MySQL server products

Client only: Install a MySQL client product without a server

Full (fully): Installs all included MySQL products and features

Custom (Manual): Manually select the products that should be installed on the system

7.1 Developer default mode detects that the following programs will not be installed successfully, click Next to go to the next installation process, skip to step eighth.

Check requirements: Requests for the following products fail, and setup will automatically attempt to resolve some of these issues. Requirements that are marked as manual cannot be resolved automatically. Click these items to try a manual recovery.

A non-installable program description was detected:

Visual Studio: is a code editing tool (can write C #, Visual Basic, C + +, TypeScript, F #), install the requirements to install Visual Studio if you install version:2012.2013.2015.2017 one of the versions

Connector/pyton 3.4: The computer has python3.6, there is no choice of 3.4 version. If you do not have Python installed, you can install some content as required.

7.2 Select MySQL server (service) 5.7.19 x64

Choose MySQL Workbench (MySQL workbook) 6.3.9 x64

Select MySQL notiyier (notification) 1.1.7 x86 (because there is only one option so select 86) Click Next to go to the next installation process, skip to step nineth.

8. When we click Next, the installer prompts: (one or mobile product requirements are not met, those that meet the requirements will not be installed/upgraded.) Do you want to continue?), here's what I chose: Yes

9. Install the selected interface to see the program we need to install next, click Execute

Install The program Progress Interface, installation takes some time. Click Dide Tails to see the installation log

11. After the program is installed, click Next

in the Product configutration page, you can see the program that needs to be configured, click Next (Page English: Now we will introduce the following Product Configuration Wizard. You can cancel at any time if you wish to leave this wizard without having to configure all products)

13. First configure the type of MySQL server and the network: type and networking (types and networks), here are two types of MySQL server, select the first type click Next.

There are two types of simple introduction

1.standalone mysql server/classic mysql replication: standalone MySQL server/classic MySQL copy

Choose this option if you want to run the MySQL server either standalone with the opportunity to later configure classic M Ysql replication: Select this option if you want to run MySQL server is standalone and have the opportunity to configure classic MySQL replication later

2. InnoDB cluster sandbox thst setup (for testing only):

InnoDB cluster sandbox thst settings (for testing only)

14. Set the server configuration type and connection port: Continue Next

Config Type: Choose development machine, which is sufficient for small and learning purposes.

Port Number: Enter 3306, or you can enter the other preferably between 3306-3309.

15. Configure the root password (the password to remember), the system prompts the weak password

add another administrator, click Add User to enter the account password Click OK (if the added administrator only allows to log on locally to change host to local ), go back to the interface and click Next

configuration MySQL name in Windows system, whether choose to start the MySQL service boot, the other has not been modified, click "Next".

18. Configure plug-ins and extension pages without modification directly to the next step:

Mysql server:apply Configuration (Application Configuration page), select Execute for installation

MySQL server application configuration log, select Finish

21. The installer goes back to the product Configutration page, where we see a successful display of the MySQL server installation and proceed to the next step:

22. Configure MySQL Router: Tick configure MySQL route for InnoDB cluster and enter the password. (If you don't want to enter a password, click on it directly) click Next.

23.Mysql router:apply configuration (App config page) Click Execute,

24. After the installation is complete, click Select Finish

25. Detecting root Password

26. Install some servers, follow the usual click Execute, click Finish

27. The program returns to the Product configuration page. Continue to the next step:

28. Install the program to complete the interface.

29. Double-click the installation package that you downloaded before running to see the products we have installed.

30. Configure the MySQL environment variable

Installed above is the time we see MySQL default installation path is: C:\Program files\mysql\mysql Server 5.7

My Computer right-click Properties à advanced system settings à environment variable à new mysql_home, install directory input:

Find path Edit: Enter%mysql_home%\bin


Open cmd input mysql–u root–p

Enter the root password

WIN10 System, Mysql-installer-community-5.7.19.0.msi installation