64-bit win7 install MySQL zip package in the form of

Source: Internet
Author: User
Tags mysql client

1) First download the ZIP package decompression.

2) Configure the environment variable configuration to the bin directory. For example, your own directory is: F:\mysql\mysql-5.6.21-winx64\mysql-5.6.21-winx64\bin


3) Create a My.ini in the directory under the same directory as the My-default.ini


The configuration inside is as follows:



[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
#设置3306端口
Port = 3306
# set up the MySQL installation directory
Basedir=f:\mysql\mysql-5.6.21-winx64\mysql-5.6.21-winx64
# Set up a storage directory for MySQL database data
Datadir=f:\mysql\mysql-5.6.21-winx64\mysql-5.6.21-winx64\data
# Maximum number of connections allowed
max_connections=200
# The character set used by the service side defaults to the 8-bit encoded latin1 character set
Character-set-server=utf8
# The default storage engine that will be used when creating a new table
Default-storage-engine=innodb

The path is subject to your MySQL installation directory.

4) Install MySQL service


Locate cmd.exe under Path C:\Windows\System32, right-click to run as Administrator (Win 7 under strict distinction between permissions, must be Administrator)
Automatic: mysqld--install [service name]
Manual: Mysqld--install-manual [service name]


Here the author provides the installation method is: Mysqld-install MySQL--defaults-file= "F:\mysql\mysql-5.6.21-winx64\mysql-5.6.21-winx64\my.ini"
Note: Be sure to change "-defaults" to "--defaults", mysqld directive does not have the-D option, while MySQL in parsing parameters, as long as the encounter xxxx-dxxxx will be the D as an option to deal with.
MySQL defaults to find C:\my.ini and C:\windows\my.ini, My.ini or my.cnf in the installation directory


5) Start and shutdown of MySQL service.

Windows + R after entering net start MySQL service for starting MySQL.

Enter net stop mysql for stop MySQL service



64-bit win7 install MySQL zip package in the form of

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.