WindowsMySQL-5.6.13解压版(zip版)安装配置教程.docxVIP

/leroy008/article/detailsindows MySQL-5.6.13解压版（zip版）安装配置教程 /mysql/1441322.html[下载MySQL 5.6.13]从MySQL官方网站找到MySQL Community Server 5.6.13的下载地址为/downloads/mysql/，在这里可以选择操作系统平台。洪哥选择的是Microsoft Windows平台。下面有三个可选的下载文件，第一个是MySQL Installer 5.6 for Windows，这将下载下来一个.msi可执行安装文件。另外有两个解压版（Zip版）分别是Windows (x86, 64-bit), ZIP Archive 和 Windows (x86, 32-bit), ZIP Archive。下载下来，分别是mysql-5.6.13-winx64.zip 和 mysql-5.6.13-win32.zip。洪哥选择的是Windows (x86, 64-bit), ZIP Archive，因为我的服务器操作系统是Windows 2008 R2 64bit。[安装MySQL 5.6.13]下载的zip包有212MB，下载了几分钟就好了。1、将mysql-5.6.13-winx64.zip 解压到D:\mysql-5.6.13\目录。2、清理里面的调试文件打开这个目录，发现里面的文件夹和文件跟一个安装好后的MySQL基本没有区别。可能你会很郁闷，这个MySQL5.6.13居然有1.04GB，呵呵，仔细一看你就会发现，里面有很有调试文件。后缀为.lib或.pdb的，其实可以删除掉。还有一些名为debug的目录，也删除掉吧。这样是不是就小很多了。3、创建my.ini作为MySQL的配置文件在D:\mysql-5.6.14-win32下，复制“my-default.ini”文件，生成“复件 my-default.ini”文件。将“复件 my-default.ini”文件重命名成“my.ini” 。修改其中的内容如下：# For advice on how to change settings please see# /doc/refman/5.6/en/server-configuration-defaults.html# *** DO NOT EDIT THIS FILE. Its 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.[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:\\mysql-5.6.14-win32datadir = D:\\mysql-5.6.14-win32\\dataport = 3306#自定义主机ID识别符，用于主从或多服务器之间识别，为 一个 int 类型server_id = 1character_set_server=utf8# 最大连接数量max_connections = 100#CREATE TABLE 语句的默认表类型，如果不自己指定类型，则使用下行的类型default-storage-engine = InnoDB# 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