MySQL5.6.11 Installation Steps (Windows7 64-bit)

1. Download MySQL Community Server 5.6.21, note select system type (32-bit/64-bit)

MySQL version of 5.7 did not succeed, the reason is unknown!

2. Unzip the MySQL archive package

Unzip the downloaded MySQL archive into a custom directory.

3. Add Environment Variables

Variable name: mysql_home

Variable Value: C:\Program files\mysql

This is the custom unzip directory for MySQL.

Add%mysql_home%\bin in Path again

4. Registering Windows System Services

Registering MySQL as a Windows system service

The operation is as follows:

1) Enter the bin directory under the MySQL decompression directory from the console (note that CMD is best run as Administrator):

2) Enter the Service installation command:

Mysqld Install MySQL--defaults-file= "C:\Program Files\mysql\my-default.ini"

A successful installation will prompt the service to install successfully.

Note: The My-default.ini file is available in the root directory after MySQL decompression, if not, from somewhere else.

The Removal Service command is: mysqld remove

5. Start the MySQL service

Method One:

The Start service command is: net start MySQL

Method Two:

Open the Administration Tools service and locate the MySQL service.

Start the service by right-clicking to start or by tapping on the left-hand boot directly.

6. Change the password of the root account

The default password for the root account is empty when the installation is complete, and you can modify the password to the specified password. Example: 123456

Method One:

C:>mysql–uroot

Mysql>show databases;

Mysql>use MySQL;

Mysql>update user SET Password=password ("123456") WHERE user= ' root ';

Mysql>flush privileges;

Mysql>quit

Method Two:

Use third-party management tools for password modification. such as Navicat for MySQL

Source:http://www.cnblogs.com/happyty/p/4131686.html

MySQL5.6.11 Installation Steps (Windows7 64-bit)