MySQL Free install version

[download MySQL 5.6.13]

From the MySQL official website mysql.com find the MySQL Community Server 5.6.13 for http://dev.mysql.com/downloads/mysql/, where you can choose the operating system platform. Here are three optional download files, the first of which is MySQL Installer 5.6 for Windows, which will download an. msi executable installation file. There are also two uncompressed versions (Zip version), namely Windows (x86, 64-bit), Zip Archive and Windows (x86, 32-bit), Zip Archive. Downloaded, respectively, are Mysql-5.6.13-winx64.zip and mysql-5.6.13-win32.zip. Hongo chose Windows (x86, 64-bit), ZIP Archive, because my server operating system is Windows 64bit R2.

[install MySQL 5.6.13]

Download the ZIP package has 212MB, downloaded for a few minutes just fine.

1, unzip the mysql-5.6.13-winx64.zip to the D:\mysql-5.6.13\ directory.

2, clean up the debug files inside
Open this directory, found inside the folder and files with a installed after the MySQL basically no difference. Perhaps you will be very depressed, this MySQL5.6.13 incredibly has 1.04GB, hehe, look carefully you will find, inside has very have debug file. A suffix of. lib or. pdb can actually be removed. There are also some directories called Debug, also deleted. This is not a lot smaller.

3. Create My.ini as MySQL configuration file
By default there is no My.ini file, which requires us to create one manually. How to create it? Do you have a template like php.ini? In fact, in the MySQL5.6.13 with a my-default.ini, can be counted as a template, but the contents of the inside is too little. So Hongo take everyone to create a my.ini by hand.
Create a text file directly, named My.ini. Open it and enter the following:

[Mysqld]

#绑定IPv4和3306端口
Bind-address = 0.0.0.0
Port = 3306

# set up the MySQL installation directory
basedir=d:/mysql-5.6.13

# Set up a storage directory for MySQL database data
Datadir=d:/mysql-5.6.13/data

# Maximum number of connections allowed
max_connections=200

Well, the parameters required for such a basic MySQL environment are sufficient.

4. Install MySQL as a service
Open a cmd.exe, switch directory to D:\MySQL-5.6.13\bin, run: Mysqld-install, prompt service installation succeeded! (The WIN8 administrator runs the command line). Run Services.msc A look, there really is a service called MySQL, start it.
Delete Service Mysqld-remove

By this, MySQL5.6.13 has been able to use the normal.

MySQL Free install version