Mysql-5.6.14-win32 for free installation decompressed version, mysql5.6 decompressed Version Download

Mysql-5.6.14-win32 for free installation decompressed version, mysql5.6 decompressed Version Download

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 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 = 3306
Default-character-set = utf8
# The client character type, which must be the same as that of the server. utf8 is recommended.
[Mysqld]
Port = 3306

Character_set_server = utf8
# Server character type. utf8 is recommended.
Basedir = D: \ ProgramFiles \ mysql5614win32
# Decompress the root directory

Datadir = D: \ ProgramFiles \ mysql5614win32 \ data
# Decompress the root directory \ data
SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

[WinMySQLAdmin]
D: \ ProgramFiles \ mysql5614win32 \ bin \ mysqld.exe
# Decompress 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:

1. Bytes. Username: yunjian registration code 81f43d3dd20872b6
   

Reprinted: https://zhidao.baidu.com/question/198835714385066205.html