MySQL 5.6 for Windows uncompressed version configuration installation

MySQL is a small but powerful database, which is very popular at present. However, the official website gives the installation package in two formats, one in MSI format and one in ZIP format. Many people under the ZIP format decompression found no Setup.exe, face a pile of files confused, do not know how to install. The following article describes how to resolve various issues during installation in this situation.

First, the Environment preparation:

1, Win7 64-bit operating system

2, Mysql-advanced-5.6.24-winx64.zip

Second, unzip mysql-advanced-5.6.24-winx64.zip to e:\ root directory, each person can according to their own computer disk space situation to decompress.

The extracted directories are as follows:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/BE/wKiom1U1zc3z15LYAAHhkFZJzpE933.jpg "title=" QQ picture 20150421121005.png "alt=" Wkiom1u1zc3z15lyaahhkfzjzpe933.jpg "/>

Once the decompression is complete, the database is not immediately available because it needs to be configured.

Third, configure the environment variables:

Mysql_home=e:\mysql-advanced-5.6.24-winx64

The configuration method is as follows:

Right-click on "Computer", select "Properties", click on the left "advanced system Settings", click the "Environment variable" button at the bottom, enter the environment variable setting form:

Select the New button in the system variable (S) below and enter Mysql_home in the Variable name text box.

Enter E:\mysql-advanced-5.6.24-winx64 in the Variable value text box and click the OK button to save.

Locate and double-click the environment variable named "Path" in the "System variable (S)" below and add E:\mysql-advanced-5.6.24-winx64\bin at the top of the variable value text box, remembering that the last semicolon cannot be dropped, then click "OK button to save the.

Edit E:\mysql-advanced-5.6.24-winx64\ The following My-default.ini file, modify the values of Basedir and DataDir two variables:

[Mysqld]

# Remove Leading # and set to the amount of RAM for the most important data

# Cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove Leading # to turn on a very important data integrity option:logging

# Changes to the binary log between backups.

# Log_bin

# These is commonly set, remove the # and set as required.

Basedir = e:\\mysql-advanced-5.6.24-winx64

DataDir = E:\mysql-advanced-5.6.24-winx64\\data

#port = .....

# server_id = ...

# Remove Leading # To set options mainly useful for reporting servers.

# The server defaults is faster for transactions and fast selects.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

Sql_mode=no_engine_substitution,strict_trans_tables

Save the file and exit.

Create a Windows service based on the configuration file you just edited.

Run the cmd command as an administrator, fight the cmd command form, and remember that you must run the cmd command as an administrator , or the creation will fail because of insufficient permissions.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/BE/wKiom1U11TLy-JDVAAEJG41WLMU896.jpg "title=" QQ picture 20150421124027.png "alt=" Wkiom1u11tly-jdvaaejg41wlmu896.jpg "/>

As you can see, first run the Mysqld-install command to create the Windows service.

Then use the net start MySQL command to start the MySQL database service.

Vi. log in to MySQL database

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/BF/wKiom1U117HRx004AAILckJVxkY678.jpg "title=" QQ picture 20150421124539.png "alt=" Wkiom1u117hrx004aailckjvxky678.jpg "/>

This article from "The Memories of Tao elder brother" blog, declined reprint!

MySQL 5.6 for Windows uncompressed version configuration installation