Installed configuration related---MySQL decompression version installation and configuration

One, download MySQL 5.6.13
MySQL Community Server 5.6.13:
http://dev.mysql.com/downloads/mysql/,
You can select an 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. Download down, respectively Mysql-5.6.13-winx64.zip and
Mysql-5.6.13-win32.zip.

Two, install MySQL 5.6.13
Download the zip package with 212MB, please be patient.

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. Maybe you will be very depressed, this MySQL5.6.13 incredibly have 1.04GB, hehe, look carefully you will find, inside there are very
Debug files. 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, just
There is too little content in it. 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

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! Run Services.msc A look, there really is a service called MySQL, start it.
By this, the MySQL5.6.13 can be used normally.

Delete MySQL service mysqld--remove

(The mysqld-nt in some articles is actually mysqld)

Third, configure MySQL 5.6.13
1, the My.ini parameter configuration

If the start of the MySQL service when the 1067 error does not start, in general, the My.ini configuration file problems, mainly check basedir and datadir two variables are configured correctly, configured as the current MySQL installation directory

2. Configure root User Login
By default, the root is a blank password, so run d:/mysql-5.6.13/bin/mysql-uroot-pdirectly, prompt for the password, the direct return to the root can enter the management of MySQL.
Root no password is harmful, give it a password. Run d:/mysql-5.6.13/bin/mysqladmin-uroot-p Password < new password > , replace < new password > with your custom password, then press ENTER.

At this point will be prompted to enter a password, in fact, refers to the original password, the original password because it is empty, so here again enter to complete the setup.

3. Other operation
After logging in with the root user and password, you are ready to proceed.

Installed configuration related---MySQL decompression version installation and configuration