Mysql 5.6.14 win32 decompressed version (Installation-free) installation and configuration tutorial, 5.6.14 installation and configuration tutorial

Mysql 5.6.14 win32 decompressed version (Installation-free) installation and configuration tutorial, 5.6.14 installation and configuration tutorial

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

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 ID is 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. Right-click C: \ Windows \ System32 \ cmd.exe and choose "Run as administrator ".(It is very important. Otherwise, an error occurs: 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 takes effect immediately.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.