mysql5.6 above (for 5.7) Free installation version Ultimate configuration

1. Unzip your mysql5.6

I unzipped the location is D:\Program files\mysql-5.6. -winx64, you can freely put in any position, do not recommend decompression to C drive

2. Come to the root directory of your extracted files, create a new My.ini file, the My.ini content is as follows:

[Client]port=3306default-character-Set=Utf8[mysqld]// set the installation directory for MySQL basedir=d:\program files\mysql-5.6. -winx64// set to MySQL data directory datadir=d:\program files\mysql-5.6. -winx64\dataport=3306character_set_server=Utf8sql_mode =no_engine_substitution,strict_trans_tables

3. From the console, go to the bin directory under the MySQL decompression directory. 4. Enter the Service installation command:

Mysqld--initialize-insecure--user=-install

If Install/remove of the Service denied! appear
Because window 7 is more restrictive than vista.
Go to C:windowsystem32 Find CMD.EXE right-click to select as Administrator, and then go to the corresponding directory to execute the command, everything is OK.

A successful installation will prompt the service to install successfully.

Note: The My-default.ini file is available in the root directory after MySQL decompression, if not, from somewhere else.

The Removal Service command is: mysqld remove

1. Start the MySQL service

The Start service command is: net start MySQL

2. Modify the MySQL default password

set authentication_string=password ('123qwe'where user=  'root' and Host ='localhost'; MySQL

Finally, say, install the MSL version do not install the zip version, otherwise it will conflict, this article only zip version

mysql5.6 above (for 5.7) Free installation version Ultimate configuration