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