Installing MySQL under Windows

1. installation package mysql_x64 (free installation version)

2. Unzip the MySQL archive package

Unzip the downloaded MySQL archive into a custom directory.

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/76/C9/wKioL1ZcWEfzjvJaAAB4agQ-4AY896.png "title=" 1.png " alt= "Wkiol1zcwefzjvjaaab4agq-4ay896.png"/>

3. Add System Environment variables

Variable name: mysql_home

Variable value:D:\mysql\mysql-5.6.27-winx64

This is the custom unzip directory for MySQL.

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/76/CA/wKiom1ZcWJST1tbnAABZZoRw1JI551.png "title=" 2.png " alt= "Wkiom1zcwjst1tbnaabzzorw1ji551.png"/>

Add%mysql_home%\bin in Path again

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/76/C9/wKioL1ZcWTPCtX19AABag49H510619.png "title=" 3.png " alt= "Wkiol1zcwtpctx19aabag49h510619.png"/>

4. Registering Windows System Services

Registering MySQL as a Windows system service

The operation is as follows:

1) from the console into the bin directory under the MySQL decompression directory:

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/76/CA/wKiom1ZcWPaR1wFaAAAQ2HtJGt0682.png "title=" 4.png " alt= "Wkiom1zcwpar1wfaaaaq2htjgt0682.png"/>

Mysqld Install MySQL--defaults-file= "D:\mysql\mysql-5.6.27-winx64\my-default.ini"

A successful installation will prompt the service to install successfully.

Note: The My-default.ini file is in the root directory after MySQL decompression, if not, can be obtained from other places

5. Start the MySQL service

The Start service command is: net start MySQL

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/76/CA/wKiom1ZcWUeBjQHYAAAedO1cAfI595.png "title=" 5.png " alt= "Wkiom1zcwuebjqhyaaaedo1cafi595.png"/>

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

This article is from the "MR-G Operations Knowledge Base" blog, please be sure to keep this source http://xpstack.blog.51cto.com/2973026/1718334

Installing MySQL under Windows