[Go]mysql-5.6.17-win32 free-installation version configuration

1. Download Mysql-5.6.17-win32; Baidu

2. Unzip to the custom directory, I am here to demonstrate the D:\wamp\mysql\

3. Copy the My-default.ini under the root directory and change the name to My.ini,my.ini replace with the following content

#以下是复制内容, it's not a copy.

[Client] port=3306 Default-character-set=utf8 #客户端字符类型, consistent with the server, recommended UTF8

[Mysqld] port=3306 Character_set_server=utf8 #服务端字符类型, recommended UTF8

Basedir=d:\wamp\mysql

#解压根目录

Datadir=d:\wamp\mysql\data

#解压根目录 \

Data sql_mode=no_engine_substitution,strict_trans_tables

[Winmysqladmin]

D:\wamp\mysql\bin\mysqld.exe

#解压根目录 \bin\mysqld.exe #以上是复制内容, it's not a copy.

4. Environment variable Configuration My Computer-Properties-advanced-environment variables-new variable mysql_home value D:\wamp\mysql find the variable path edit, add it later;%mysql_home%\bin

5. Run the input cmd, or locate the C:\Windows\System32\cmd.exe, and go to the MySQL extract directory bin subdirectory,

C:\Documents and settings\administrator>cd\ c:\>d:

D:\>CD Wamp

D:\WAMP>CD MySQL

D:\WAMP\MYSQL>CD bin

D:\wamp\mysql\bin>

D:\wamp\mysql\bin>mysqld-install Tip: Service successfully installed. And the installation is successful.

(cmd command: cd\ return root d: Enter D CD wamp into Wamp folder)

6. Start, stop, and move out of the MySQL service to start the MySQL service:

net start MySQL stop MySQL service:

net stop MySQL removal from MySQL service:

Mysqld-remove start the service here to facilitate next steps.

7. Change the root password: Enter cmd in the run,

Skip to the installation directory/bin,

D:\wamp\mysql\bin>mysql-uroot

Mysql>show databases;

Mysql>use MySQL;

Mysql>delete from User where user= "";

Mysql>update User Set Password=password (' NewPassword ') where user= ' root '; Mysql>flush privileges;

mysql>quit;

FLUSH privileges: Force MySQL to reload permissions and take effect immediately

At this point you can log in with the following command:

D:\wamp\mysql\bin>mysql-uroot-p Enterpassword:newpassword

8. Common commands

Mysql>show databases; Show All Tables

Mysql>use mysql; switch to table MySQL

Mysql>show tables; Show the structure of the table END

Note CMD to run as administrator enter the MySQL input command with a semicolon ending