Windows 10 MYSQL Installer Installation (mysql-installer-community-5.7.19.0.msi)
Category Programming Technology
- Go to the official website and find the required installation package: https://dev.mysql.com/, path: DOWNLOAD --> MYSQL Community Edition(GRL) --> MYSQL on Windows (Installer & Tool)
Or directly click https://dev.mysql.com/downloads/windows/installer/ to view the latest version.
Find the required installation package.
Click download. Here, the installation version (mysql-install-community) is selected.
Choose to download without logging in.
Double-click to run the downloaded mysql-installer-community-5.7.19.0.msi, the program will take some time to run, please wait.
After successful operation, enter the welcome interface. Select "I agree to the agreement," otherwise you cannot proceed to the next step.
Enter the type selection page, I need MySQL cloud services so I chose "developer default" (step 7.1 is the default installation steps). If you only want to install MySQL server, choose custom mode (step 7.2 is to select the server type you need, which is used for some data analysis).
- developer default (Developer Default): Install all products required for MySQL development
- server only (Server Only): Install only MySQL server products
- client only (Client Only): Install only MySQL client products without a server
- full (Full): Install all included MySQL products and features
- custom (Custom): Manually select the products to be installed on the system
7.1 The developer default mode detects that the following programs will not install successfully, click "Next" to enter the next installation process --> skip to step 8.
Check requirements: The requests for the following products failed, the installation program will automatically attempt to resolve some of these issues. Requirements marked as manual cannot be resolved automatically. Click on these items to attempt manual recovery.
Detected programs that cannot be installed:
Visual Studio: A code editing tool (can write C#, Visual Basic, C++, TypeScript, F#), if you install it, install the required Visual Studio version: 2012, 2013, 2015, 2017
Connector/pyton 3.4: Since the computer already has Python 3.6, the 3.4 version was not selected. If you have not installed Python, you can install some content as required.
7.2 Select MySQL server (Service) 5.7.19 x64
Select MySQL Workbench (MySQL Workbook) 6.3.9 x64
Select MySQL Notifier (Notification) 1.1.7 x86 (since there is only one choice here, x86 was selected) Click "Next" to enter the next installation process --> skip to step 9.
When we click "Next," the installation program prompts: (One or more product requirements have not been met, those compliant products will not be installed/upgraded. Do you want to continue?), Here I chose: YES
On the installation selection interface, you can see the programs we need to install next, click "Execute"
Installation progress interface, installation will take some time. Click "Hide details" to see the installation log
After the program is installed, click "Next"
On the product configuration page, you can see the programs that need to be configured, click "Next" (Page English introduction: Now we will introduce the configuration wizard for the following products one by one. You can cancel at any time if you wish to leave this wizard without configuring all products)
First configure the type and network of MySQL server: type and networking, there are two types of MySQL server here, select the first type and click "Next."
Two types of simple introduction
- Standalone MySQL server/classic MySQL replication: Independent MySQL server/classic MySQL replication. Choose this option if you want to run the MySQL server either standalone with the opportunity to later configure classic MySQL replication
InnoDB cluster sandbox thst setup (for testing only): InnoDB cluster sandbox thst setup (for testing only)
Set the server configuration type and connection port: continue "Next" Config Type: Select Development Machine, enough for small and learning purposes. Port number: Enter 3306, or enter another one preferably between 3306-3309.
Configure the root password (remember this password), the system prompts that this password is weak
Add other administrators, click "Add User" enter the account and password and click "OK" (if the added administrator is only allowed to log in locally, change the host to
Configure the name of MySQL in the Windows system, whether to choose to start the MySQL service at boot, other modifications were not made, click "Next."
No modifications were made directly to the plugins and extensions page, click "Next":
MySQL server: apply configuration page, select "Execute" to install the configuration
MySQL server application configuration log, select "Finish"
The installation program returns to the product configuration page, at this time we see the successful installation display of MySQL server, continue "Next":
Configure MySQL router: Check "Configure MySQL route for InnoDB cluster" and then enter the password. (If you do not want to enter the password, you can directly click) Click "Next"
MySQL router: apply configuration page, click "Execute",
After the installation is complete, click "Finish"
Check the root password
Install some servers, click "Execute" as usual, after completion click "Finish"
The program returns to the product configuration page. Continue "Next":
Installation program completion interface.
Double-click to run the previously downloaded installation package, you can see the products we installed.
Configure MySQL environment variables
The above installation shows that MySQL is installed by default in the path: C:\Program Files\MySQL\MySQL Server 5.7
Right-click "My Computer" --> Properties --> Advanced System Settings --> Environment Variables --> New MYSQL_HOME, enter the installation directory:
Find path and edit: enter %MYSQL_HOME%\bin
Open cmd and enter mysql –u root –p
Enter the root password
>
Original link: https://www.cnblogs.com/xiaodingdong/p/7223245.html
** Click me to share notes
-
-
-