Go MySQL5.6.22 Installation

Original Path Http://jifeng3321.iteye.com/blog/2181517?utm_source=tuicool As a bank project has been done, so has been using Oracle and DB2, but recently I want to toss something, these two databases are a bit big, so get a MySQL to use, but I am win8 system, under a few are not good use, it seems that the official website (because English is not flattering, forced not to .......)。 Originally opened official website: www.mysql.com very easy down to the WinDOS 64-bit installation program, version is the MySQL 5.6.22. The result down, dizzy, how did not install the program ... Look, the original is the green version, record the configuration steps: 1, download the installation files (official website win 64 5.6.22 version). 2, after the download is complete, extract to the specified folder 3, configure environment variables:

Variable name: mysql_home

Variable Value: D:\Program Files (x86) \mysql-5.6.22-winx64

Add%mysql_home%\bin to Path;

4. Registering Windows Services

Create a My.ini file under C:\WINDOWS

Edit the My.ini content as follows:

#-------------------------------------------------

[Client]
port=3306
Default-character-set=utf8

[Mysqld]
# Set the installation directory to MySQL
Basedir=d:\program Files (x86) \mysql-5.6.22-winx64
# Data Directory set to MySQL
Datadir=d:\program Files (x86) \mysql-5.6.22-winx64\data
port=3306
Character_set_server=utf8

# using most of the online model, specifically after the detailed study
Sql_mode=no_engine_substitution,strict_trans_tables

#-------------------------------------------------

About Strict_trans_tables mode record:

• Inserting null values on NOT NULL fields is not supported
• Insert ' value for self-growing field is not supported, can insert null value
• The text field is not supported with a default value

5, console into D:\Program Files (x86) \mysql-5.6.22-winx64 (Bin directory under the installation directory) 6, Installation Services: Mysqld.exe-install wipe, reported a install/remove of the Service denied! Refused, online check, the original is the system permissions problem, Solution: Find C:\Windows\System32 under the Cmd.exe, run as Administrator, re-execute the above command 7, start mysql execution command: net start MySQL Boot success:

8. Change the root user password (the root password is empty by default) >mysql-uroot

Mysql>show databases;

Mysql>use MySQL;

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

Mysql>flush privileges;

After the modification can log in, test the success of any changes, you will find prompt password error:

--The original does not support spaces ...

OK, the installation is over!

Go MySQL5.6.22 Installation