Windows Server installation MySQL5.6.26 graphic tutorial

Download MySQL5.6.26

The URL for downloading MySQL is as follows.

• Http://www.mysql.com/

Click "Downloads 」.

Click "Community (GPL) Downloads" under "MySQL Community Edition (GPL 」.

Click DOWNLOAD under MySQL Community Server 」.

This is because the Windows environment is used. Therefore, Select "Select Platform", Select "Microsoft Windows", and click "Download" in "Windows (x86, 32-bit), MySQL Installer MSI 」.

The download page appears. It looks like "Note: MySQL Installer is 32 bit, but will install both 32 bit and 64 bit binaries." Windows 32-bit and 64-bit use the same file. Windows (x86, 32-bit), MSI Installer
"Download 」.

The logon page of MySQL.com is displayed. You can also register it here. However, this time, we do not register and only download it. Click "No thanks, just start my download .」.

Click save 」.

Save MySQL5.6.26 to any directory to complete the download process.

1) install MySQL5.6.26

Double click the downloaded mysql-installer-community-5.6.26.0.msi file and click Run 」.

The following preparation page is displayed.

Select "I accept the license terms" and click "Next 」.

Select "Full" for the installation type and click "Next 」.

Display the list of products required for Full MySQL installation. If you want to use the features shown here, install the required products after MySQL installation. Click "Excute" here 」.

Next, install Microsoft Visual C ++ 2013 Redistributable (x64) and Microsoft Visual Studi Tools for Office Runtime 2010 」.

Install Microsoft Visual C ++ 2013 Redistributable (x64)

The "Microsoft Visual C ++ 2013 Redistributable (x64)" page is displayed. Check "I agree to the license terms and conditions" and click "Install 」.

Click Close to complete the installation of Microsoft Visual C ++ 2013 Redistributable (x64.

Install Microsoft Visual Studi Tools for Office Runtime 2010

The "Microsoft Visual Studi Tools for Office Runtime 2010" installation page is displayed. Check "I have read accept the license terms." and click "Install 」.

Click Finshi to complete the installation.

"Status" indicates Manual installation after "Manual". Click "Next" here 」.

Click "Yes 」.

Click "Excute 」.

Click "Next 」.

2) initial configuration of MySQL5.6.26

Perform initial configuration for the MySQL to be installed and click "Next 」.

Configure MySQL server 5.6.26

MySQL is used as the Server. Therefore, select "Server Machine" for "Config Type 」.

Use the default port 3306 for TCP/IP, check Show Advanced Options, and click Next 」.

Set the password of the MySQL root user and click "Next 」. Other MySQL users are not added here.

Shows whether to start MySQL with Windows service.

Start the MySQL Server at System Startup check box when starting MySQL with Windows service, while MySQL Windows service name uses the default MySQL56.

Configure the Windows User name for starting the MySQL56 service, and select Custom User when specifying the User name 」. Use the default settings here.

Click "Next" after setting 」.

The MySQL log configuration page is displayed. Use the default settings here and click "Next 」.

After confirming the MySQL settings, click "Excute 」.

Click Finish 」.

Configure Smaple and Examples5.6.26

Click "Next" to configure "Smaple and Examples5.6.26 」.

Test whether the MySQL database can be connected normally.

After "Connection succesful" is displayed, click "Next 」.

Click "Excute 」.

Click Finish 」.

Complete Product Configuration and click Next 」.

Click Finish 」.

Through the above operations, MySQL installation and initial configuration are completed.

3) FAQs

When installing MySQL5.6.26, if the warning page appears, you need to download "Microsoft. NET Framework 4 Client Profile 」.

Visit the following Microsoft website.

• Http://www.microsoft.com/zh-CN/download/details.aspx? Id = 17113

Select Chinese (simplified) and click download 」.

Click "no". Thank you. Continue 」.

Double-click the "dotnetfx40_client_setup.exe" file to start installation. Select "I have read and accept license terms" and click "install 」.

The installation page is as follows.

Click "finish 」.