MySQL 5.7 Installation tutorial

First, MySQL https://downloads.mysql.com/archives/installer/

Say it in the front.

Why have I tried and used many MySQL versions of the same type of product, and have to write this blog? Based on Mysql-installer-web-community-5.7.18.1.msi

is because of recent research work related to data analysis .

First of all, explain the difference between Mysql-installer-web-community's mysq and Mysql-installer-communityl's version .

The explanation of my crossing net is this:

Choosing the right file:

If you have a online connection while running the MySQL Installer, choose the Mysql-installer-web-community file.
If you don't have a online connection while running the MySQL Installer, choose the Mysql-installer-community file.

This means that if you are running the MySQL installer you can surf the Internet (network connection), choose Mysql-installer-web-community;
If you are not able to surf the Internet (no network connection) while running MySQL setup, select Mysql-installer-community.

In popular parlance, one is an online installation and one is an offline installation. Look at the size of these two files to know.

Download of Mysql-installer-web-community-5.7.18.1.msi

http://ftp.ntu.edu.tw/MySQL/Downloads/MySQLInstaller/

Installation of Mysql-installer-web-community-5.7.18.1.msi

Download the installation package, mysql-installer-web-community-5.7.18.1

First step: Double-click

Step two: Wait for a while

Step three: double click to run, and click "I Accept ... "as shown in.

Fourth step: click "Next" to Enter the installation type selection interface, for learning data analysis, only 2, 3 modules, do not install all , choose "Custom" can.

Fifth step: after selecting "Custom", the interface of selecting the installation module appears.

From the know, really bring a lot. I don't show them all.

because, I was installed to do data analysis, so just need one of the 2, 3 modules can be, not all installed ,

　

　

Note: after selecting "Full" , enter the installation environment check interface, for each module, the required environmental requirements are listed, stand-alone "Excute", will be the installation of the environment tocheck and install the appropriate environment, labeled "Manual "needs to be manually installed.  If the direct stand-alone "Next", will skip the environmental inspection process, directly install the module meets the requirements of the environment, do not meet the requirements are not installed.

Description: Because MySQL is installed in the Windows environment, it is necessary to support some of Microsoft's class libraries. For General Open
These libraries are available on the sender's computer, but may not be available for non-programmer computers and need to be installed.
Microsoft Visual C + +, . Net Framework 4.5

Have to be installed.

Microsoft Visual C + + and . Net Framework 4.5

https://www.microsoft.com/zh-CN/download/details.aspx?id=52685

download of the. Net Framework 4.5

I've got it on my computer, and I don't have a demo.

OK, manual installation is required, then, then click again to reinstall.

It will, automatically for a period of time, download well. Have a cup OF coffee, go!

　　After clicking "excute", each module starts to download, it is automatically installed after the download is complete, and the download progress prompt appears. A lengthy wait period, especially for MySQL Server5.7.18 downloads.

　　　　

It took me half a day to be here. Perhaps, for example, everyone in the installation of this step, will sometimes have to shut down the computer, nothing, after closing, directly repeat the above steps here.

　　The default is to select the first one, directly stand-alone "next".

　　No tube, direct stand-alone "next".

Enter the MySQL Super Administrator account "root" password, and you can also create a regular administrator.

I generally like to give root password to Rootroot

　

This log, I copied out, to show you.

Beginning configuration Step:stopping Server [if necessary]ended configuration Step:stopping server [if Necessary]beginn ing configuration step:writing configuration fileended configuration step:writing configuration filebeginning Configura tion step:updating firewalladding Firewall rule for MySQL57 on port 3308.Successfully added firewall rule. Ended configuration step:updating firewallbeginning configuration step:adjusting Windows Service [if Necessary]attempti Ng to grant Network Service require filesystem permissions. Granted permissions. Adding New servicenew Service addedended configuration step:adjusting Windows Service [if Necessary]beginning Configurati On step:initializing Database [if necessary]deleting Data folder shippedattempting to run MySQL Server with--initialize- Insecurerunning process:c:\program files\mysql\mysql Server 5.7\bin\mysqld.exe--defaults-file= "C:\ProgramData\ Mysql\mysql server 5.7\my.ini "--initialize-insecure=on--consolewaiting for the server stops: C:\Program files\mysql\mysql server 5.7\bin\mysqld.exe--defaults-file= "C:\ProgramData\MySQL\MySQL server 5.7\my.ini "--initialize-insecure=on--console2017-06-09t08:09:15.505766z 0 [Warning] TIMESTAMP with implicit DEFAULT value is Depr Ecated. --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-06-09t08:0 9:15.535767z 0 [Warning] ' no_zero_date ', ' no_zero_in_date ' and ' Error_for_division_by_zero ' SQL modes should is used with Strict mode. They'll be merged with strict mode in a future release.2017-06-09t08:09:23.327213z 0 [Warning] innodb:new log files cre Ated, lsn=457902017-06-09t08:09:24.559284z 0 [Warning] innodb:creating FOREIGN KEY constraint system tables.2017-06-09t08:09:25.174319z 0 [Warning] No existing UUID have been found, so we assume that's the first time t Hat This server has been started. Generating a new uuid:f3a3b10f-4cea-11e7-babd-00ffb027ca9a.2017-06-09t08:09:25.273324z 0 [Warning] Gtid table is not rea Dy to BE used. Table ' mysql.gtid_executed ' cannot be opened.2017-06-09t08:09:25.277325z 1 [Warning] [email protected] is created With an empty password! Please consider switching off the--initialize-insecure option. Finished initialize databaseended configuration step:initializing Database [if necessary]beginning configuration step:s Tarting serverstarting MySQL as a serviceended configuration step:starting serverbeginning configuration step:applying S ecurity settingsattempting to update security settings. Updated security settings. Ended Configuration step:applying Security settingsbeginning configuration step:creating user accountsattempting to Add New MySQL usersadded New users.ended configuration step:creating user accountsbeginning configuration step:updating Star T Menu linkattempting to verify command-line client shortcut. Verified command-line client shortcut. Verified command-line client shortcut. Ended configuration step:updating Start Menu linkbeginning Configuration step:Updating Firewall for MySQL document data Feature setended configuration step:updating Firewall for MySQL document data F Eature Set

complete the installation, stand-alone "next".

Here I am, to MySQL for Windows, it is [email protected], then the port is 3308.

One of my images in [email protected], to 3306, is another of my same type of MySQL software. And 192.168.80.110:3306 is MySQL in Linux on my big data platform.

Later, we start, then click below to

Problems
Issue 1: Unable to start the secondary program because the computer is missing api-ms-win-crt-runtime

http://blog.csdn.net/huqiao1206/article/details/50768481

Issue 2: Download and install Workbench separately
https://dev.mysql.com/downloads/workbench/

Extended Learning

MySQL Workbench type MySQL client tool download, install and use navicat Premium MySQL client download, install and use (Blogger recommended) sqlyog MySQL client download, Installation and use (flagship edition) (recommended) Download, install and use of SQLyog MySQL client (Enterprise Edition) (hack) Navicat for MySQL client download, install and use sqlyog mysql client download, Install and use (normal edition) MySQL server type MySQL client tool download, install and use (blogger recommended)

MySQL 5.7 Installation tutorial