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

Source: Internet
Author: User

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

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.