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

MySQL is a kind of relational database management system which is very popular at present. The installation package is available in two formats: Zip format and msi format. Where the MSI format can be directly clicked to install, according to the installation prompts it gives installation, General MySQL will be installed in C:\Program files\mysql\mysql Server x.x (x.x is the version number) of the directory; Zip format is its own decompression, After decompression, MySQL is ready to use, but it needs to be configured. I use the zip format, so this is the main description in the zip format of MySQL download, installation and configuration.

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.

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

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, execute the mysqld –install 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 CMD net start mysql  .

Seventh step: Log in to MySQL

In cmd, enter mysql -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 Tutorial (GO)