MySQL 5.6.13 uncompressed version (Zip version) installation configuration method _mysql

[Download MySQL 5.6.13]

From the MySQL official website mysql.com find the MySQL Community Server 5.6.13 download address for http://dev.mysql.com/downloads/mysql/, where you can choose the operating system platform. Hongo selected the Microsoft Windows platform. Below are three optional downloads, the first of which is the MySQL Installer 5.6 for Windows, which downloads an. msi executable installation file. Another two uncompressed versions (Zip) are 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 selected Windows (x86, 64-bit), ZIP Archive, because my server operating system is Windows 2008 R2 64bit.

[install MySQL 5.6.13]

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

1. Extract the Mysql-5.6.13-winx64.zip to the D:\mysql-5.6.13\ directory.

2, clean up the debugging files inside
Open this directory, found inside the folder and file with a good installed MySQL basically no difference. Maybe you will be very depressed, this MySQL5.6.13 incredibly have 1.04GB, hehe, a careful look you will find that there are very debugging files. Suffix is. lib or. pdb, which can actually be deleted. There are also some directories called Debug, which are also deleted. That's a lot smaller.

3, create My.ini as the MySQL configuration file
There is no My.ini file by default, which requires us to create one manually. How do you 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 took us 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 the MySQL installation directory
basedir=d:/mysql-5.6.13

# set up a repository of MySQL database data
Datadir=d:/mysql-5.6.13/data

# allow maximum number of connections
max_connections=200

OK, so a basic MySQL environment requires enough parameters.

4, install MySQL into a service
Open a Cmd.exe, the directory to switch to D:\MySQL-5.6.13\bin, run: Mysqld-install, prompt service installation success! Run Services.msc A look, there really is a service named MySQL that starts it up.

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

[Configure MySQL 5.6.13]

After installation, you have to configure to use, right.

1, the My.ini parameter configuration
About My.ini inside more complex parameter configuration, Hong Elder brother here do not introduce. The brothers who need to optimize MySQL can refer to the manual of the MySQL official website.

2. Configure root User Login
By default, root is a null password, so direct run d:\mysql-5.6.13\bin\mysql-uroot-p, prompt input password, direct return can be the root into the management of MySQL.
Root no password is too scary, let's set a password for it. Run d:\mysql-5.6.13\bin\mysqladmin-uroot-p password < new password >, replace < new password > with your custom password and press ENTER. At this point will be prompted to enter the password, in fact, refers to the original password, the original password because it is empty, so here and then enter to complete the setup.

3, other operations
Once you have logged in with the root user and its new password, you can complete all other normal work. In this Hongo will not repeat.

About the MySQL 5.6.13 installation configuration process, Hongo on the introduction so much, I hope to help you, thank you!