MySQL Free install version configuration method

1th step: Download such as installation package

2nd step: Unzip the MySQL package and then go to the unpacked installation package

Copy the My-default.ini and rename it to My.ini (I have done)

Copy the following to My.ini and save

1 [Client]2port=33063 default-character-set=UTF84 5 #客户端字符类型, consistent with the service side, recommended UTF86 7 [Mysqld]8 9port=3306TenCharacter_set_server=UTF8 One  A #服务端字符类型, it is recommended that UTF8 -  -basedir=d:\mysql-5.6.16-Win32 the #解压根目录 -  -datadir=d:\mysql-5.6.16-Win32\data -  + #解压根目录 \data -  +Sql_mode=No_engine_substitution,strict_trans_tables A  at [Winmysqladmin] -  -D:\mysql-5.6.16-Win32\bin\mysqld.exe -  -#解压根目录 \bin\mysqld.exe

Modify your own configuration Basedir,datadir, and the last item

3rd Step: Add Environment variables

Path: add: D:\mysql-5.6.16-win32\bin;

4th step: Join MySQL to Windows system services

CMD in the bin directory of the CD to the MySQL decompression directory:

Install with the following command:

Mysqld Install MySQL--defaults-file= "D:\mysql-5.6.16-win32\my.ini"

Prompt service installation succeeded

Note: Remove service command: mysqld remove

5th step: Start the MySQL service

Command: net start MySQL

6th step: Change the password of the root account

Open cmd input mysql-uroot

show databases;

Use MySQL;

This command completes the password modification:

Update user set password= "123456" where user= "root";

Flush privileges;

The password is now changed to: 123456

Exit

The 7th step: At this point in the cmd input MySQL can also go in, but the permissions are not the same;

You can try it: show databases; compare

8th step: Now MySQL is ready to use

For easy connection:

Desktop Shortcuts: New shortcuts, right-click Desktop

Object Position Input: C:\Windows\System32\cmd.exe

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-win32\bin"/k mysql-uroot-p123456 databasename
3) After the modification is saved, simply double-click the shortcut to connect to the database named DatabaseName

MySQL Free install version configuration method