MYSQL 5.6.14 Win32 version 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.

The MySQL 5.6.14 Win7 32-bit version-free configuration method is shown below:

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 an administrator (very important, otherwise have permission problems, will error: Install/remove of the Service denied!), Enter MySQL extract directory bin subdirectory, enter mysqld install MySQL--defaults-file= "Your root 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, instantly live

Install SQLyog and use the registration code:

Download address Http://downinfo.myhostadmin.net/ha_SQLyog_Enterprise.rar After the download, run the directory under the SQLyogEnt.exe, prompted to enter the registration code. User name Yunjian Registration code 81F43D3DD20872B6

The above is a small set to introduce the MySQL 5.6.14 Win32-free version of the configuration of the installation of the tutorial, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!