MySQL 5.6.14 Win32 version (install-free) installation configuration tutorial _mysql

Mysql-5.6.14-win32 for the installation of uncompressed version, installation version (http://dev.mysql.com/downloads/installer/5.5.html) there are many drawbacks.
MySQL 5.6.14 Win7 32-bit free installation version configuration

1. Download mysql 5.6.14; Download Address: Http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.14-win32.zip

2. Extract to Custom directory , mine is D:\ProgramFiles\mysql5614win32\bin

3. Copy the My-default.ini under the root directory, change the name to My.ini,my.ini and replace it with the following content

[Client]
port=3306
Default-character-set=utf8
#客户端字符类型, consistent with the service side on line, recommended UTF8
[mysqld]
port=3306

character _set_server=utf8
#服务端字符类型, suggest UTF8
basedir=d:\programfiles\mysql5614win32
#解压根目录

datadir=d:\ Programfiles\mysql5614win32\data
#解压根目录 \data
sql_mode=no_engine_substitution,strict_trans_tables

[Winmysqladmin]
D:\ProgramFiles\mysql5614win32\bin\mysqld.exe 
#解压根目录 \bin\mysqld.exe

4. Environment variable Configuration

Your unpacked directory.

Mysql_home D:\ProgramFiles\mysql5614win32

Add%mysql_home%\bin behind path ;

5. Find C:\Windows\System32\cmd.exe, right key-run as Administrator (Very important, otherwise have permission problem, will error: Install/remove of the Service denied!), into the MySQL extract directory bin subdirectory, input mysqld Install MySQL--defaults-file= " Your solution to the directory \my.ini ", Hint:

Service successfully installed.

6. Start, stop, remove MySQL service

Start MySQL service: net start MySQL
Stop MySQL service: net stop MySQL
Remove MySQL service: mysqld-nt--remove

7. Modify Root Password:

Run to enter CMD, skip to the installation directory/bin,

D:\programfiles\mysql5614win32\bin>mysql-uroot

D:\programfiles\mysql5614win32\bin>show databases;

D:\programfiles\mysql5614win32\bin>use MySQL;

D:\programfiles\mysql5614win32\bin>update user SET Password=password ("root") WHERE user= ' root ';

D:\programfiles\mysql5614win32\bin>flush privileges;
D:\programfiles\mysql5614win32\bin>quit

FLUSH Privileges: force MySQL to reload permissions and take effect immediately.

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.