MySQL 5.6 Installation Configuration

MySQL 5.6.17 download installation diagram _ Baidu Experience
Http://jingyan.baidu.com/article/4b07be3c67853c48b380f311.html

Windows 8 System Add MySQL to environment variable _ Baidu Experience
Http://jingyan.baidu.com/article/3c48dd34782b68e10be35882.html

Installation steps:

MySQL 5.6.17 download installation diagram

Tools/Materials

• Windows (x86, 32-bit), MSI installer:http://dev.mysql.com/downloads/installer/5.6.html
• Microsoft. NET Framework 4.0

Installation steps

1. 1

Run the install installation and proceed to the next step.

1. 2

Developer default installation Type

Server only as Server

Client only

Full fully installed type

Custom user-defined installation type

Choose the installation according to your own situation, we have a custom installation here as an example:

1. 3

Here are 3 options,

1.Developer Machine (development machines), personal desktop workstations, with minimal system resources

2.Server machine (server), MySQL server can run with other applications, such as FTP, email, and Web server. The MySQL server is configured to use the appropriate scale of system resources.

3.Dedicated MySQL server machine (dedicated MySQL servers): This option represents a server that only runs the MySQL service. Assume that the run is not running other applications. The MySQL server is configured to use all available system resources.

Choose according to your own situation, the general Web server Select the second, server machine can! PC installation choice First, Developer machine is better.

1. 4

Continue with the next installation. Complete the installation

END

Experience content is for reference only, if you need to solve specific problems (especially in the areas of law, medicine, etc.), we recommend that you consult the relevant professionals in detail.

Environment configuration:

Windows 8 system joins MySQL to environment variables

In general, we often use the Windows system for system development, through the CMD in Windows to manage the MySQL database, we need to add MySQL to the environment variable

Tools/Materials

• Cmd
• MySQL Database

Method/Step

1. Run the MySQL database, open cmd in Windows8, enter Mysql-h localhost-u root-p, if shown, prove that the environment variable is not included in MySQL

1. Find the Mysql.exe installation path, copy it (take My computer as an example), usually mysql.exe are stored in the mysql/bin/directory.

1. Locate the "environment variable" in WINDOWS8, look for "path" in the system variable, click the Edit button

1. Copy the path of the Mysql.exe to the Variable value content box, and note that you need to ";D: \web\mysql\bin" in front of the first need to add "semicolon", and then determine all the way.

1. Restart MySQL, repeat step 1, observe the changes, you can find the ability to operate the database

END

Precautions

• Note You need to restart MySQL after configuring environment variables
• Note When adding mysql.exe, be careful to add semicolons before the root directory

Note: The environment is configured as much as possible in the front of path.

I used to have SQL Server in the back and there will be a Error1045 error.

MySQL 5.6 Installation Configuration