MySQL5629forWindows2012r2解压缩版安装配置教程.docx

MySQL 5.6 .29 x64 for Windows 解压缩版配置安装教程MySQL安装文件分为两种，一种是msi格式的，一种是zip格式的。如果是msi格式的可以直接点击安装，按照它给出的安装提示进行安装，一般MySQL将会安装在C:\Program Files\MySQL\MySQL Server 5.6.29 该目录中；zip格式是自己解压，解压缩之后其实MySQL就可以使用了，但是要进行配置。解压之后可以将该文件夹改名，改成你需要的名称，放到合适的位置，如放到D:\server\mysql路径中。当然你也可以放到自己想放的任意位置。完成上述步骤之后，很多用户就开始直接使用MySQL，会出现图示的错误。这是因为没有配置所致。一、添加环境变量我的电脑-属性-高级-环境变量编辑PATH（如果系统变量没有则新建一个），在其后面添加mysql bin文件夹的解压文件的存放路径，如果存放在D:\server\mysql的目录下，那么系统变量的PATH变量值添加为 ;D:\server\mysql\bin(注意；是追加,不是覆盖)。如果新添加的就不用加 ； 号，如：变量名: PATH 变量值：D:\server\mysql\bin 二、配置my.ini文件配置完环境变量之后，接下来要配置my.ini文件。mysql-5.6.29默认的配置文件是在刚才解压后存放的根目录里，如D:\server\mysql\my-default.ini，把my-default.ini改名为my.ini后进行配置。下面给出MyQSL-5.6.29的典型配置参考：简单配置# *** upgrade to a newer version of MySQL.[mysqld]character_set_server=utf8character_set_client=utf8# 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:\Server\Mysql5.6.29datadir=D:\Server\Mysql5.6.29\dataport=3306# server_id = .....# 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 2、详细配置# *** default location during install, and will be replaced if you# *** upgrade to a newer version of MySQL.[client]no-beepport=3306[mysql]default-character-set=utf8[mysqld]basedir=D:/Server/mysql-5.6.29datadir=D:/Server/mysql-5.6.29/dataport=3306server_id=1character-set-server=utf8default-storage-engine=INNODBsql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONlog-output=FILEgeneral-log=0general