MySQL 5.6 (Win7 64-bit) download, install and configure graphics tutorials

A Tools

WIN7 64-bit operating system

Two Steps

First step: Download the installation package

Download Address: http://www.mysql.com/

As of Now (2016/7/24), the latest version of the official website is 5.7.13, but not using this version, the download is the previous version of 5.6.31.

The platform defaults to Windows.

Confirm your machine word length, click Download.

Step Two: Unzip

After unpacking, you can rename the folder and put it in the appropriate location. I renamed the folder to MySQL Server 5.6 and placed it in the D:\Program files\mysql path. Of course you can put it anywhere you want.

Step Three: Configure (do not rush to use, preferably configured first)

After you configure the environment variable path, you can open MySQL later without switching directories. Principle: Simply put, the path inside the environment variable is the lookup directory of the CMD system. You enter a command, how does the system know that this command is there? How did the system do it? In fact, the system is in the current directory and the system environment variable path inside of the search, to find the first to prevail, can not find the error. So after you set up path, you can save the hassle of switching directories with commands every time. An analogy: The system is like a bus, according to the established route. The path inside the environment variable is the driving route. Go to a station (find the first directory) and get Off (run).

Procedure: Computer--System Properties, advanced system configuration, environment variables

Select Path, after which you add: the path to your MySQL Bin folder (for example: my: D:\Program files\mysql\mysql Server 5.6\bin) modified path is:

Path=.;D: \program Files\mysql\mysql Server 5.6\bin (Note: 1. The semicolon must be added in English after the original path; 2. is append, not overwrite. )

Fourth Step: Modify the configuration file

Do not start MySQL after configuring environment variables, also need to modify the configuration file, mysql-5.6.1x default configuration file is D:\Program files\mysql\mysql Server 5.6\ My-default.ini, you can build a My.ini file yourself, in which you modify the configuration:

[Mysqld] Basedir=c:\program files\mysql\mysql Server 5.6 (MySQL directory) datadir=c:\program files\mysql\mysql server 5.6\ Data (MySQL directory \data)

Mydefault.ini content is as follows:

My.ini content is as follows:

Fifth step: Install MySQL

First, run CMD as an administrator (you must run as administrator, or you will not have enough permissions to make an error)

Next, enter the D:\Program files\mysql Server 5.6\bin directory,

Then, executemysqld –installthe command and, if there is no error, prompt the installation to succeed.

Note: If you have previously installed MySQL, but for some reason it is not uninstalled, when you install MySQL again, you will be prompted that the service already exists. The sc delete mysql command is available, the previous version is removed, and the Mysqld–install command is executed.

Sixth step: Start the MySQL server

Enter the command in CMDnet start mysql.

Seventh step: Log in to MySQL

In cmd, entermysql -u root -p, first login without password, direct enter, login successful.

The command to exit MySQL is exit. The direct close CMD window is not exited, and the exit is not exited until you enter exit.

MySQL 5.6 (Win7 64-bit) download, install and configure graphics tutorials