MySQL 5.6 for Windows 解压缩版配置安装
mysql服务下载:http://pan.baidu.com/s/1c2yrems
MySQL 是一个小巧玲珑但功能强大的数据库,目前十分流行。但是官网给出的安装包有两种格式,一个是msi格式,一个是zip格式的。很多人下了zip格式的解压 发现没有setup.exe,面对一堆文件一头雾水,不知如何安装。下面笔者将介绍如何解决此情况下安装过程中的各种问题
方法/步骤
-
MySQL 安装文件分为两种,一种是msi格式的,一种是zip格式的。如果是msi格式的可以直接点击安装,按照它给出的安装提示进行安装(相信大家的英文可以看 懂英文提示),一般MySQL将会安装在C:\Program Files\MySQL\MySQL Server 5.6 该目录中;zip格式是自己解压,解压缩之后其实MySQL就可以使用了,但是要进行配置。
-
解压之后可以将该文件夹改名,放到合适的位置,个人建议把文件夹改名为MySQL Server 5.6,放到C:\Program Files\MySQL路径中。当然你也可以放到自己想放的任意位置。
-
完成上述步骤之后,很多用户开始使用MySQL,但会出现图示的错误。这是因为没有配置环境变量所致。配置环境变量很简单:
我的电脑->属性->高级->环境变量
选择PATH,在其后面添加: 你的mysql bin文件夹的路径 (如:C:\Program Files\MySQL\MySQL Server 5.6\bin )
PATH=.......;C:\Program Files\MySQL\MySQL Server 5.6\bin (注意是追加,不是覆盖)
-
配 置完环境变量之后先别忙着启动mysql,我们还需要修改一下配置文件(如果没有配置,之后启动的时候就会出现图中的错误哦!:错误2 系统找不到文件),mysql-5.6.1X默认的配置文件是在C:\Program Files\MySQL\MySQL Server 5.6\my-default.ini,或者自己建立一个my.ini文件(或者直接my-default.ini改名),
在其中修改或添加配置(如图):
[mysqld]
basedir=C:\Program Files\MySQL\MySQL Server 5.6(mysql所在目录)
datadir=C:\Program Files\MySQL\MySQL Server 5.6\data (mysql所在目录\data)
-
以管理员身份运行cmd(一定要用管理员身份运行,不然权限不够),
输入:cd C:\Program Files\MySQL\MySQL Server 5.6\bin 进入mysql的bin文件夹(不管有没有配置过环境变量,也要进入bin文件夹,否则之后启动服务仍然会报错误2)
输入mysqld -install(如果不用管理员身份运行,将会因为权限不够而出现错误:Install/Remove of the Service Denied!)
安装成功
-
安装成功后就要启动服务了,继续在cmd中输入:net start mysql(如图),服务启动成功!
此时很多人会出现错误,请看注意:
注意:这个时候经常会出现错误2和错误1067。
如果出现“错误2 系统找不到文件”,检查一下是否修改过配置文件或者是否进入在bin目录下操作,如果配置文件修改正确并且进入了bin文件夹,需要先删除mysql(输入 mysqld -remove)再重新安装(输入 mysqld -install);
如果出现错误1067,那就是配置文件修改错误,确认一下配置文件是否正确。
-
服务启动成功之后,就可以登录了,如图,输入mysql -u root -p(第一次登录没有密码,直接按回车过),登录成功!
END
2.
mysql根据配置文件会限制server接受的数据包大小。
有时候大的插入和更新会被max_allowed_packet 参数限制掉,导致失败。
查看目前配置
show VARIABLES like '%max_allowed_packet%';
显示的结果为:
+--------------------+---------+ | Variable_name | Value |
+--------------------+---------+ | max_allowed_packet | 1048576 |
+--------------------+---------+
以上说明目前的配置是:1M
若执行show VARIABLES like '%max_allowed_packet%';出现一下错误
performance_schemasession_variables’ doesn’t exist
解决方法:
1、使用管理员身份打开终端,输入:mysql_upgrade -u root -p ****** //以管理员的身份重新检查变更新表
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAmAAAADvCAIAAADacP+jAAAS+UlEQVR4nO3dUYIiqbIAULfbu3Rp76PfeG0JggCzLDI958tKySBAIaZ6LLn9+fPnBgC8UCABIKBAAkBAgQSAgAIJAAEFEgACCiQABBRIAAgokAAQUCABIPAokPcna6HujaOS/Iw2/5ch9K780GBfwlZ6SfJpr88m/4v5nOJNlb95Ku3zW4Ztll/KjznF6/hwolT5KX8L5PP7oLi2e9en4uwmz783ovdHmoT9+1R9Aw1TeokzzHyrfM7ypprNLRl7L07exVQCvziTO7+IL06UatHFhvPj/vz5k29S4VaYbKyn2Mt62rEv3PV+v88XXxSDJC9E5TXaKp+zvKlmczvqdVn2W5O584v44kSpVlxsOJ/QFsgXva2wvpc9Rwg3hTZUeMtsnHsjm4go/2GevakYjquNkzd+uSt8XEyvF2fbfIZJhgHbHJKOpuL0VNrUb0+mIkm1dzGfwLB9L5neLWGe4UCKE5V3+tJL0m+SzDD/YvspvXHl7Zfz7w1qeQjhxF7WsEAmZt9Yt/6LXXnci9NL6blxmG1vRJXgyfWFceVxZqfrHr0ow/Tq4/p8PsM4SaovjysJ53F67v9KWvbuHV7M52phYm/NGG/l13dhPofJFAc7lU/bJk9peVxhzBcLcXr5L+RZ7C7Pf20IZ/VOgbyVX4DwdV1+gXu3917Ftn1lOG3jfHRtki/5VHIYjn3YrHJj0sXO+czO833m/VaPU3FU4+HULTdO2lSmKwk71SCRxOmlnbfvNXt+djjYtv2s4fz0bnnJv55z2PU7FoZwVmv/D/JZZbLC60e9wMN72/dTZSz1Z2ffhcVekrC9YVYaFKd6n3xmE+49dVScivqNw5b1tIsv0LD97LS/2W9PEid8qth+GL8+8DULMQ/Jv97dVD5HxdzU8FOs9/8kQcL3aNigd7HXaeUFHr458tyGeQ6fTZKsPO4FzMfetnlzPpOUfjefSsw8t/pAinFC+WS2/da7GE7FMPlh45deetFmX4vlIedx8u7aqR6mcci4ihbiHJL/7d+XeDn/vIurOervIHtvzTzysNP2lcjj3PpvguHQinn2UqqkOhxvOKIk/7BNEj9PPsnqd/PpxQmv550mac8m3wued1HJJ4kchgrnrZ3AvNPlNm3LNpkkz6lR5/HDPJOWw/j1UFN68fPGSf73/vwnXb+f//uhdrfhN+m078jfzGZjs5Pz0+/p3fLhWAuvVOWWe8dsWPvGx3zR9G5YIG+2ztRuk7NbPhxr+fX9oTdGEtZb8QO+a5L3LJAA8MsUSAAIKJAAEFAgASCgQAJA4PFNOvXPWPPCpAFcUPtNOrf/vkojpx48UyABriYskEPqwYt2QvxaCXBu4XexPh6E/+ia/HtsfvE2880at6jGhPFnryc/zubfm4cweQDO5LlAvuzpvcftj/X2xbKRhMobzD5uc6vnP0wSgBMb/gbZPm5/fL74rH2qd28Yqve4Fz+P0158yWc43np7AE4v+X+Qw4KRtK8/NWxfL0jFMrlcICtJvjyragKcVfIp1krB6LWpFJjEVIGcfXxU/gokwJUlfwe5UABeIiQXc20ybadtesV8bp0CuZB/Lx8ATm/Pb9JRbAD4ZRsWyIXfOAHgYBsWSAD4fQokAAQUSAAIKJAAEFAgASDwKJDtZ0eP+ijpMM5Pf2B1+CeMP9rv5z+Lu9sHgGfnwWeYgS2E38UaPn7HbgXyceVXanOv5ec7/ZjZlDYcAvB1Ht+k87jy+QL5eR/Lp9jRbvNzOAUSOJ+2QD7r/aZ1f9K2T35jCx8nwXvx25SS/PN8hvLkX7LKh1AZ77D98niLcXrJLMSfHVfSNcCnVQrkvXbqRe9x79722XrMqQ002Z0rQSrjuhXmZ5hSvd96wgtxZuf/px8D/I7ib5C3pgA8axuHcXoNihv68gbaNl6+vZLqsH07FWE+vXmeSjiJX7m9fdzmk1+fjbOQMMCPqP8/yMfj3uaVbGr5vbMJ5H1VElu+vZLqQv6VaalbeIF6zSpzXrk+G2d57ACHqX+K9agC0O599cb3fxXHOOyxfnsl1Xfmp9i+nvBCnNn8f/rx85X6JAC8q/53kOFTvV2s3aCHcR7X840yvx42C+NP7bZ5evmQw/btEMKUZlMNxzsbp71xmM/wehi23v7WmR+AH3Sib9JJNu7fskkaABzvRAXytvTL35ckA8DBzlUgAeBDFEgACCiQABBQIAEgoEACQOAbzoPkL/MMMOEbzoPkL/MMMOE7z4MEgIFvPg+y1+8w4bU4eZKHxJ8a7zB+JXmAy7rweZDv53nUePNUfzrPsKO1fgG+yLXPg0zqRJjS85X2Qfi4HqeS5Jvx877CIPXHAN/lC8+DrOTZu1jMYTm9Q+IXX6DD5xngUi58HuSbebahZvPM0zs8fj7JeZDi/DynWh4cwDl9z3mQ9TzrPS7EyVN9M35lvO30hvF7WS0MDeCUTvRNOvnGDQBHOlGBvK3+cgYA085VIAHgQxRIAAgokAAQUCABIKBAAkDg8U06H/iA6Nk/fXr2/H/am++f5M8xhz22LXt/3+lFBKryb9I51tn3pp/+r4cfivxJ7xfI+9OXReShkjftS5xD0gO+zicLJD2XmfNDCmTxV73emzYpipeZZ+ATkgKZb0DtFpZsbcvtb7VNLWw/3DR7F4vtF67nyedTVIyTPC4O+c15eDP/MFQynHwekmmpqIy3vZh0WpmfXhzg054LZGVXWnj8UNy5hnGSsG/m+bIx3aNt8fD8e82OmofeU8vzkNz7zjw8dzoV9r70Mg0tjCuct6PiAJ/28hvk7GIuLvjw4nKcJGz98bOXUO1UJPkncfK0k8h5/pUglaketu81exlv/jicn2H+w7BTNybDnEppOK5w3hbmJ4wDfNryP7HWHz+Eu8BCnCTsmzHz7pL8F6INWx41D72niu2H8d957XrxK2GLDd5PrzI5yVMLCcxOHfAjNiyQt3+3tuFOcWCeeXfF/IfzkER+J05xXO3jdp7D7g6c52H+vR+L8SvjGqa0MK5ezNlkktzaOMBPef47yL9X2sf3mX8yah/fmg0rj/OsuBe0wZP8b+mGFfYY5p/ckoQaDuGdOJXxhqEqg6rEr4fKc2h/TNok8ZNJqGTVaxlez8Pm8zkbpzKfwLs2/CaddlNbu5eHZHdOGuxm7c1wiqEBO9qwQN5WtzYbYiiZllPM2CmSBC5ozwIJAL9MgQSAgAIJAAEFEgACCiQABB4Fsv2s4FEfHRzG8QHFv37os5o+AgqwIj/u6qiN9QIF8jMZ1qdi4Q9gljIC+FaPb9J5XPl8gdzfx/IvdjSbz9nnH+AXtAXy2eOpsIi2N+bXe4+T4L34bUpJ/sfmM5yHpH0lz3fi5+Nda1+5DnBBlQJ5P+i7WNvreeN6/CT5ehfF9vU8kyEX8+wlMBWz0sXsnFfmH+Dcir9B3ppC8qxtHMZZ2P3f3KArPVbCJkUlmYf72wUyjD/MM2/fPi7G740X4Jrq/w/yed9Pduewl/ze2QTyviqJ5aEqV5IcngdbSXVhvMN8KlM6nM9KpwCXVf8U63Bjnd2gw2crcR7yoVU6nc1/dqLCrot5HpVPkt5Uv0n829N8JiMFOJP630GGT/V2yXZ3HsYZbtxtR8PR9fLsxUnaz453KtV8+O31YT63qBD2Uk36rYw3yQfgxE70TTrtDn5gQAD4x4kK5K3wG+HHggBwcecqkADwIQokAAQUSAAIKJAAEFAgASDwmQL50x8cvcYHU8+eP/y6/I99b1YZUz75G+RPvzXP/tY/e/7wux4rKKyR7WMYUCCBC6gURVsEcx5fVh7+K2Xvv7x6/6T5fLH3bCWrYfwwzkLyyfV6v700evF7qRbzB1qV5WMdMef5NI/2PTR8k1UeP8wWmDfjVwZyyLgWhnD/z0L+QGu4fCwipi0UyFuhPg0bJHrNZuNXqtStUCDrmRe7brubyh9oVZaPdcSctQIZXhlu6MV3Z6/ZbPzhQO7lAjmVf6Xr4V1TNwKV5WMdMScvkI8fKzv+WoF5CX5g/OG9L+Nd7re1dnv77P3JsFP4cuFavi0tYbjd/i2Qf9VrT76h99r3nurFmb3eLoZ7vxD2rhfH25Mn0wbp5d9mAiR6K6i3tCFT+TOPhbfUN7wL26oW1loATikpkLO/Nr1/4zV8+fABLsJ3sQJAQIEEgIACCQABBRIAAgokAAR2Pg8y/AMmHw0FevwdJEfa/Lir8L1+aFLARfT+EFmBZJECCVxApSjaQJiz/3mQbT5h18A3UyA53onOg6x0AXyn4V5hx2Da5udBKpBARWWvsGkwZ/PzIBVIoEKB5HgnOg+y0gXwtXqF0L7Bos3Pg7xFb/rwFoDhDmPrYILzIAEg4DxIAAj4LlYACCiQABBQIAEgoEACQECBBIDAzudBHtv75/sFPszfQXKkzY+7OnW/U/bPEDbXfqnIy/X2Kch8Q4Hcn5mBN1WKooXGnP3PgwwvFvtdjvNOnrPX741K18CzcFm9PLa+mHOi8yCP6nc5zs/lWZwZoGe4zK0ypm17HmT7nj4kseG99bXUa5PkU7kFWFBZ5hYaczY/D7J3vZ5kPc/ZxTObZ3KjdQtvqixzC405JzoPMol//1fe73L+Sdg35+fxY6VfINRbR7NLG/7f5udBzr7LK/0mcXrj6qnMQ+X6rTMPwJThDmOVMeEC50H+9Lu/rbLWGMD1XeM8SHULgIP5LlYACCiQABBQIAEgoEACQECBBIDAN5wHCXwJfwfJkb72uKt9MgEO8dhhwhrZPoaB7yyQ+2QCHKJSFC185pzuPMgwVNJ+eN2CgQuobBfWO3MufB5kko91AhczLJBWPdMucx5kvX09E+AshgWybQMDFzsPstK+nglwFgokxzvReZBhMmv5WDBwPb11PdyaIHai8yCH6U2til584LyGO4xVz4QLnAcJAMe7xnmQAHAw38UKAAEFEgACCiQABBRIAAgokAAQ2PY8SJ+DBWb5O0iOtOdxV4+W3s1AUW/fUCBZtHmBBKioFEUbC3N2Pg8yudhLppePVQHXpkByvG3Pg2wL22y/w3yAyxhuFzYBpm14HuRsfEURqPz3tD2BORueB1m5XYEEnimQHG/D8yArtyuWwIteIbQVsGjD8yB7wV8ah4uhHgq4nuEOYzdggvMgASDgPEgACPguVgAIKJAAEFAgASCgQAJAQIEEgMC250FuZTb/s48XTsrfQXKkPY+72tNs/mcfL5zLY8WFNbJ9DAMKZJ0CCduqFEVLkjk7nwfZxkmSzPMJ27cp9eLM5t9rvzZvwFC4ll8eW1zM2fY8yJ973I6lmOrs6up1Ws8TKBouN4uLaRueB5l32r7XZ9vf/q2LyS1r+ffaL08sMFRZbtYXczY8D3K2eCwUm2F67+Tfa1/J0wKGNZXlZn0xZ+fzIN/sN8lnmF49/0TSaTLJU10AD4/lU196kNnwPMjZfouFZ5j8SzJt2OTGXpyX9sMIleBAz3CHscSYsOF5kGd5N7dVcC3bs4wX4LvseR7k+xHO5dvGC3ACvosVAAIKJAAEFEgACCiQABBQIAEgcKXzIHvxr/oB0auOC5a1i+LliiXDhNMdd5VESOLvvyrW0tt/XPAxj+UQ1sj2MQycq0AuR9h8VVx1XPAxlaJovTDnROdBDvNM8il2PZyE2+Q85DeGSf7EuODyKsvNemHOic6DHEaorJA3+50de3F+htM1Nc/whYbL32Jh2onOgxxGGK6QSr+9tdRe7LXv9TU7rkr84pTC5VWWv/XCnBOdBzmMMJvPVHovVSppX7leCbUQB75WZflbL8w50XmQt9EbvbJCEkn7sN+jHh8VH75cb3+wZFh0rvMge+178Z9/rCyMJMPwx8o89JKvzMNCHPhmvfV7VyBZ8IXnQd47ju0FgHNzHiQABHwXKwAEFEgACCiQABBQIAEgoEACQGDD8yAXPr/qU6/Azd9Bcqw9j7taexP/ylvfYoNNPHaAsEa2j2FAgXyHxQabqBRFC5Y5O58H2d7S6zeM/xKk0vVwXL1kinn25icPkgytfQq+U2WNWCzM2fA8yFunNizEnyoklcbJIhzGWZi3l7HXpxq+TbI2709+IzVOa8PzIHuh7o1h/KlCkjTo9Zuk0bZfmNjnCMVb4DslazNcRDC24XmQvVDD2/MMF24fBpkaZmViK/HzW+A7VbYji4U5O58H+fJ4If5UIVkY1zC3ZDKn4veyHQ4Kvke4Hm+T+wD8z4bnQQ7rx7DfsH1lVQzjJ1NRifPSIG9fybw4LvgSyTp6/vE3UuOENjwP8kBhGveOTyZzSI+bTDLANe15HuQhNknj2SEpbTgugAvyXawAEFAgASCgQAJAQIEEgIACCQAB50G+0+9nbJsY7KZdLC9XLCUmOO7q2Ag/ZNvEYB+PZRLWyPYxDCiQx0b4IdsmBpuoFEXriDnOg+xFqI+3knMSJ5m0+7+G+cPXGq67tg0MOA8ybF8cV2URVvJ/aVMcL/AwXJsWEbP+D6C40o4bJdp6AAAAAElFTkSuQmCC)
mysql_upgrade官网解析:http://dev.mysql.com/doc/refman/5.6/en/mysql-upgrade.html
2、重启数据库:
net stop mysql
net start mysql
修改方法
1) 方法1
可以编辑my.cnf来修改(windows下my.ini),在[mysqld]段或者mysql的server配置段进行修改。
max_allowed_packet = 100M
成功