win7下mysql5.6的zip版安装

1、下载zip包

      http://dev.mysql.com/downloads/mysql/ 

2、配置my.ini

以下是简单的ini配置，其中

basedir和datadir改为自己的路径。

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[client]
port = 3306
default-character-set=utf8

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
basedir = D:\\softwore\\mysql-5.6.21-win32              #注意\\
datadir = D:\\softwore\\mysql-5.6.21-win32\\data
port = 3306
# server_id = .....
character_set_server = utf8

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

 

3、安装启动

    注意以管理员运行cmd，切换到mysql的bin目录下

    执行mysqld -install

         net start mysql

 

安装过程中遇到过

报错误 2

报错误 5

报错误 1067

主要注意以管理员运行cmd，切换到mysql的bin目录，正确配置ini文件。