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:
- Bytes. Username: yunjian registration code 81f43d3dd20872b6
Reprinted: https://zhidao.baidu.com/question/198835714385066205.html