MySQL Server 5.6 解压版安装配置
MySQL解压版下载地址为:
http://dev.mysql.com/downloads/mysql/5.6.html#downloads
安装及配置步骤:
①将MySQL的zip包解压到路径C:\Program Files\MySQL\MySQL Server 5.6(可选的)
![](https://images2015.cnblogs.com/blog/841412/201511/841412-20151121003047249-1345750135.png)
③my-default.ini原先的内容为
![](https://images2015.cnblogs.com/blog/841412/201511/841412-20151121003430108-2074399529.png)
改为(zip文件的解压路径,以及目录下的data目录)
![](https://images2015.cnblogs.com/blog/841412/201511/841412-20151121003234327-867941084.png)
④在电脑中环境变量的path项后面追加C:\Program Files\MySQL\MySQL Server 5.6\bin(zip解压的路径下的bin目录)
⑤以管理员的身份运行cmd,进入解压版的bin目录下,输入mysqld -install进行安装
![](https://images2015.cnblogs.com/blog/841412/201511/841412-20151121004009046-1682584307.png)
⑥输入net start mysql回车
![](https://images2015.cnblogs.com/blog/841412/201511/841412-20151121004517452-1653249098.png)
⑦输入mysql -u root -p回车,第一次登入不用输密码直接回车就可以了
⑧修改密码:
mysql> update mysql.user set password=PASSWORD('123456') where User='root';
mysql> flush privileges;
mysql> update mysql.user set password=PASSWORD('123456') where User='root';
mysql> flush privileges;