MySql 5.6.14 Win32 bit installation-free decompression configuration tutorial, mysql5.6.14

MySql 5.6.14 Win32 bit installation-free decompression configuration tutorial, mysql5.6.14

Mysql-5.6.14-win32 for free installation decompressed version, installation version (http://dev.mysql.com/downloads/installer/5.5.html#downloads) has many drawbacks.

Mysql 5.6.14 win7 32-bit installation-free configuration method is as follows:

1. Download mysql 5.6.14;: http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.14-win32.zip

2. decompress the package to the custom directory. My files are D: \ ProgramFiles \ mysql5614win32 \ bin.

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

[Client] port = 3306default-character-set = utf8 # client character type, which must be consistent with the server. We recommend utf8 [mysqld] port = 3306character_set_server = utf8 # server character type. We recommend utf8basedir = D: \ ProgramFiles \ mysql5614win32 # extract the root directory datadir = D: \ ProgramFiles \ mysql5614win32 \ data # extract the root directory \ datasql_mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES [WinMySQLAdmin] D: \ ProgramFiles \ mysql5614win32 \ bin \ mysqld.exe # extract the root directory \ bin \ mysqld.exe

4. Environment Variable Configuration

Your extract directory

MYSQL_HOME D:\ProgramFiles\mysql5614win32

% MYSQL_HOME % \ bin is added to path;

5. Find C: \ Windows \ System32 \ cmd.exe, right-click it, and run it as an administrator (it is very important. Otherwise, an error will be reported: Install/Remove of the Service Denied !), Go to the bin subdirectory of the mysql extract directory and enter mysqld install MySQL -- defaults-file = "your extract root directory \ my. ini". The following message is displayed:

Service successfully installed.

6. start, stop, and remove the MYSQL Service

Start MYSQL service: net start mysql

Stop MYSQL service: net stop mysql

Remove mysql service: mysqld-nt -- remove

7. Modify the root password:

Run cmd and jump to the installation directory/bin,

D: \ ProgramFiles \ mysql5614win32 \ bin> mysql-uroot

D: \ ProgramFiles \ mysql5614win32 \ bin> show databases;

D: \ ProgramFiles \ mysql5614win32 \ bin> use mysql;

D: \ ProgramFiles \ mysql5614win32 \ bin> UPDATE user SET password = PASSWORD ("root") WHERE user = 'root ';

D: \ ProgramFiles \ mysql5614win32 \ bin> flush privileges;

D: \ ProgramFiles \ mysql5614win32 \ bin> QUIT

Flush privileges: Forces MySQL to reload permissions and generate them immediately

Install sqlyog and use the registration code:

Bytes. Username: yunjian registration code 81f43d3dd20872b6

The above is a small series of MySql 5.6.14 Win32 bit installation-free and decompressed configuration tutorials, I hope to help you, if you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!