How to install mysql-5.6.22-winx64 compressed version under Windows

This article is to refer to the installation method on the Internet, after the successful installation, wrote a summary. If there is a wrong place, please point out, thank you. 650) this.width=650; "src=" Http://img.baidu.com/hi/jx2/j_0080.gif "alt=" J_0080.gif "/>

First, download mysql-5.6.22 compressed version

:http://dev.mysql.com/downloads/mysql.

MIS for the installation version, where the main write zip version of the configuration. The installation process recommends that administrator users be used, and other users may fail to install (purely speculative) because of permissions.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/58/CF/wKiom1S9Cx2SLCgMAAEjk9m-x7s965.jpg "style=" width : 700px;height:151px; "title=" 1.jpg "width=" "height=" 151 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1s9cx2slcgmaaejk9m-x7s965.jpg "/>

Second, decompression

Unzip the downloaded stuff to any location, such as: D:\Program files\mysql-5.6.22.

Third, configure environment variables

environment variable, advanced system settings, properties, computer, new environment variable

Variable name: mysql_home, the variable value is the path of the folder you want to install mysql-5.6.22, and mine is: D:/program files/mysql-5.6.22-winx64. Then add:;%mysql_home%\bin at the end of the system variable Classpath value.

Iv. Create a My.ini file and put the My.ini under C:\Windows

My.ini Content If there is an error or is missing, it causes a startup failure, error 1067. Detailed My.ini configuration information can be found on their own information. My My.ini file is shown below:

[Mysqld]

back_log=255

key_buffer_size=16m

Basedir = D:/program files/mysql-5.6.22-winx64

DataDir = D:/program Files/mysql-5.6.22-winx64/data

Port = 3306

Server-id = 1

User=mysql

Character-set-server=utf8

[Client]

Default-character-set=utf8

V. Registering MySQL as a Windows system service

          1) from the console into your MySQL bin directory. Method: Win+r Open the Run, enter CMD, open the Command Line window. Input d: Enter, enter the D packing directory, and then enter cd\program Files\mysql-5.6.22-winx64\bin Enter.

2) Enter Mysqld.exe-install. If the service successfully installed appears, the installation succeeds if install/remove of the service denied! is because of user rights issues, enter C:\Window\System32 to find CMD.EXE right-click to select as Administrator, and then enter the corresponding directory to execute the command, everything OK. The command to remove the service is:mysqld remove.

Vi. start the MySQL service

Start the service command:net start MySQL. You can also manage services such as computers, find MySQL, start.

Seven, 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.

From the console into the MySQL bin directory,

mysql–uroot    

Mysql>show databases;

Mysql>use MySQL;

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

Mysql>flush privileges;

Mysql>quit

Eight, MySQL configuration installation is complete, you can download third-party management tools to simplify the use of MySQL, such as:Navicat for MySQL

         download good, after the installation is complete, find the online registration code crack , and then create a new connection,

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/CD/wKioL1S9G5qBstKMAACyEc4FOXM240.jpg "style=" float: Left; "title=" 2.jpg "alt=" Wkiol1s9g5qbstkmaacyec4foxm240.jpg "/>

Commection Name: The connection name can be arbitrarily filled out, easy to identify and differentiate later

Host NAME/IP Address: Fill in the hostname of the server (must be able to resolve) or the server IP address, if the machine can be completed localhost or 127.0.0.1

Port: Fill in the default 3306 if you haven't modified it.

User Name:root

Password: You just modified the root password to be the set password.

Then there seems to be a test connection in the lower left corner, which can be tested for connections. After success, it is the visualization of the database operation.

This article is from the "half Period," blog, please make sure to keep this source http://bangejuhao.blog.51cto.com/9826086/1605944

How to install mysql-5.6.22-winx64 compressed version under Windows