How to install and configure MySQL5.6.13 decompressed version (zip version) _ MySQL-mysql tutorial

Hong Gang tried MySQL5.6.13 in the past two days. I feel pretty good. some of them say they are a rich and handsome version. The installation and configuration process of MySQL5.6.13 decompressed version (zip version) is recorded as follows, hoping to provide some reference for those who need to install this version. [Download MySQL 5.6.13]

On the MySQL official website mysql.com, locate http://dev.mysql.com/downloads/mysql/for MySQL Community Server 5.6.13, and select the operating system platform here. Hong Ge chose Microsoft Windows. Below are three optional download files, the first is MySQL Installer 5.6 for Windows, which will download a. msi executable installation file. Two other decompressed versions are Windows (x86, 64-bit), Zip Archive, Windows (x86, 32-bit), and ZIP Archive. Download, respectively, mysql-5.6.13-winx64.zip and mysql-5.6.13-win32.zip. Hong Ge chose Windows (x86, 64-bit) and ZIP Archive, because my server OS is Windows 2008 R2 64bit.

[Install MySQL 5.6.13]

The downloaded zip package is 212 MB. it takes a few minutes to download the package.

1、extract mysql-5.6.13-winx64.zip to D: \ mysql-5.6.13 \ directory.

2. clear the debugging files
Open this directory and find that there is basically no difference between the folders and files in it and a installed MySQL. You may be very depressed. this MySQL5.6.13 actually has 1.04 GB. If the suffix is. lib or. pdb, you can delete it. Delete some directories named debug. Is it much smaller.

3. create my. ini as the MySQL configuration file
By default, the my. ini file does not exist. you need to create one manually. How to create it? Is there a template like php. ini? In fact, MySQL5.6.13 with a my-default.ini, can be counted as a template, but the content is too little. So Hong Ge took you to create a my. ini manually.
Directly create a text file named my. ini. Open it and enter the following content:

[Mysqld]

# Binding IPv4 and 3306 ports
Bind-address = 0.0.0.0
Port = 3306

# Set the installation directory of mysql
Basedir = D:/mysql-5.6.13

# Set the directory for storing 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 enough.

4. install MySQL as a Service
Open cmd.exe, switch directory to D: \ MySQL-5.6.13 \ bin, run: mysqld-install, prompt service installation successful! Run services. msc. check that there is indeed a service named MySQL, and start it.

At this point, MySQL5.6.13 can be used normally.

[Configure MySQL 5.6.13]

After installation, you must configure it before use, right.

1. parameter configuration of my. ini
For more complex parameter configurations in my. ini, Hong Ge will not introduce them here. To optimize MySQL, you can refer to the MySQL manual on the official website.

2. configure root user logon
By default, the root is empty password, so run d: \ mysql-5.6.13 \ bin \ mysql-uroot-p directly, prompt to enter the password, directly press enter to enter the root identity to enter the management MySQL.
It is so horrible that the root user does not have a password. let's set a password for it. Run d: \ mysql-5.6.13 \ bin \ mysqladmin-uroot-p password <新密码> , Set <新密码> Replace it with your custom password and press enter. The system will prompt you to enter the password, which actually refers to the original password. because the original password is empty, you can press enter to complete the settings.

3. Other operations
After logging in with the root user and his new password, you can complete all other operations. Hong Ge won't go into details here.

Regarding the installation and configuration process of MySQL 5.6.13, Hong Ge has introduced so much and hopes to help you. thank you!