Configure MySQL free install under Windows

1. Download Mysql:mysql5.6.16win64.zip

2, decompression and put to the D packing directory, so that D:\mysql-5.6.16-winx64 under a

My.ini file (three places to unify the path)

#如果没有my-default. ini, you can create your own new My.ini or get the ######################################################### [client] port from somewhere else=3306    default-character-Set=UTF8 [mysqld] Port=3306Character_set_server=UTF8 Basedir=d:\mysql-5.6. --winx64 #解压目录 DataDir=d:\mysql-5.6. --winx64\data #解压目录下data目录 Sql_mode=no_engine_substitution,strict_trans_tables [winmysqladmin] D:\mysql-5.6. --winx64\bin\mysqld.exe#########################################################

3. Configure Environment variables

Mysql_home

D:\mysql-5.6.16-winx64

And

Path

;%mysql_home%\bin

4. Registering MySQL as a Windows system service

The administrator opens CMD first

D:

CD D:\mysql-5.6.16-winx64\bin

The following actions are followed

Enter the Service installation command:

Mysqld Install MySQL--defaults-file= "D:\mysql-5.6.16-winx64\my.ini"
A successful installation will prompt the service to install successfully.
#注: The My.ini file is placed in the root directory after MySQL decompression
#移除服务命令为: Mysqld Remove

5. start the MySQL service

Open the Administration Tools service and locate the MySQL service.
Start the service by right-clicking to start or by tapping on the left-hand boot directly.

6. 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. such as: 123456
C:>mysql–u Root
mysql>show databases;
mysql>use MySQL;
mysql>update user SET Password=password ("123456") WHERE user= ' root ';
Mysql>flush privileges;
Mysql>quit
 
7. mysql Console shortcut established:
1) object location input, new shortcut, right-click, Desktop: C:\Windows\System32\cmd.exe
shortcut name self-defined, OK, shortcut established successfully
2) Right-click the shortcut you just created, and then change the target column to the MySQL startup parameter:
C:\Windows\System32\cmd.exe "D:\mysql-5.6.16-winx64\bin"/k mysql-uroot-p inventory
Explanation: cmd path "mysql Path bin directory"/k mysql-u user name-p password database name
3) Click OK to save after the modification, double click the shortcut to connect to MySQL database

8. Common Mistakes

(1) No Start-up service

C:\users\jl>mysql-u root-******2003 (HY000): Can' localhost'  (10061)

Done