MySQL Free installation configuration

Get ready

Download the latest stable version on MYSQ official website http://dev.mysql.com/downloads/mysql/

Version Brief reference:
1. MySQL Community Server Community version, open source is free, but does not provide official technical support.
2. MySQL Enterprise Edition is available for a fee and can be tested for 30 days.
3. MySQL Cluster Cluster Edition, open source free. Several MySQL servers can be packaged as one server.
4. MySQL Cluster CGE Premium Cluster edition, fees apply.
As a developer, select MySQL Community Server (GPL) to

Note: Windows (x86, 64-bit), MySQL Installer MSI, this is the installation file, this tutorial is mainly to configure free installation files,
Click on other Downloads: Download the free install version.

2. Configure Environment variables:
Unzip the downloaded zip file to d:/program files (x86)/mysql-5.6.19-winx64
Set environment variables (not required, I'm here to facilitate use on the command line)

Add environment variables: Mysql_home=d:/program Files (x86)/mysql-5.6.19-winx64
Modify environment variables: add%mysql_home%/bin after path; (in English ";" Separate each variable)

3. Configure My.ini
Copy and modify D:/program Files (x86)/mysql-5.6.19-winx64/my-default.ini to My.ini
Modified (added):
[Mysqld] #绑定IPv4和3306端口bind-address = 0.0.0.0port = 3306# Set the installation directory for MySQL basedir=d:/mysql-5.6.13# Set the data storage directory for the MySQL database datadir=d:/mysql-5.6.13/data# the maximum number of connections allowed max_connections=200</span>
Well, the parameters required for such a basic MySQL environment are sufficient.

4. Installation Services
Open a cmd.exe, switch the directory to D:/mysql-5.6.14-winx64/bin (if you performed step 1, you configure the environment variable, you do not need to switch directories),
Run:
Mysqld-install
Tips:
Service successfully installed.
Note: If the WIN7/WIN8 system is installed, it may appear: Install/remove of the Service denied!
The workaround is to:
Search cmd, right-click to proceed as Administrator, and then go to the appropriate directory to execute the command.

5. Start the service
Start the service
net start MySQL
Stop Service
net stop MySQL

6. Start MySQL
Configure root User Login
By default, root is a blank password, so run directly
Mysql-uroot-p
When prompted to enter a password, the direct return to the root can enter the management of MySQL.

7. Set the password
Run
Mysqladmin-uroot-p Password < new password >

Replace < new password > with your custom password, and 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.

MySQL free installation configuration