MySQL解压版下载地址为:
http://dev.mysql.com/downloads/mysql/5.6.html#downloads
安装及配置步骤:
①将MySQL的zip包解压到路径C:\Program Files\MySQL\MySQL Server 5.6(可选的)
![MySQL Server 5.6 解压版安装配置 MySQL Server 5.6 解压版安装配置](https://image.shishitao.com:8440/XFVzZXJzXGNvZGVyZXgyNTIyXEFwcERhdGFcUm9hbWluZ1xUZW5jZW50XFVzZXJzXDg3MjIwNjU0NFxRUVxXaW5UZW1wXFJpY2hPbGVcQkYoX0dHUl85QFtHOTRXWjJOJFBIJUwucG5n.png?w=700&webp=1)
![MySQL Server 5.6 解压版安装配置 MySQL Server 5.6 解压版安装配置](https://image.shishitao.com:8440/aHR0cDovL2ltYWdlczIwMTUuY25ibG9ncy5jb20vYmxvZy84NDE0MTIvMjAxNTExLzg0MTQxMi0yMDE1MTEyMTAwMzA0NzI0OS0xMzQ1NzUwMTM1LnBuZw%3D%3D.png?w=700&webp=1)
③my-default.ini原先的内容为
![MySQL Server 5.6 解压版安装配置 MySQL Server 5.6 解压版安装配置](https://image.shishitao.com:8440/aHR0cDovL2ltYWdlczIwMTUuY25ibG9ncy5jb20vYmxvZy84NDE0MTIvMjAxNTExLzg0MTQxMi0yMDE1MTEyMTAwMzQzMDEwOC0yMDc0Mzk5NTI5LnBuZw%3D%3D.png?w=700&webp=1)
改为(zip文件的解压路径,以及目录下的data目录)
![MySQL Server 5.6 解压版安装配置 MySQL Server 5.6 解压版安装配置](https://image.shishitao.com:8440/aHR0cDovL2ltYWdlczIwMTUuY25ibG9ncy5jb20vYmxvZy84NDE0MTIvMjAxNTExLzg0MTQxMi0yMDE1MTEyMTAwMzIzNDMyNy04Njc5NDEwODQucG5n.png?w=700&webp=1)
④在电脑中环境变量的path项后面追加C:\Program Files\MySQL\MySQL Server 5.6\bin(zip解压的路径下的bin目录)
⑤以管理员的身份运行cmd,进入解压版的bin目录下,输入mysqld -install进行安装
![MySQL Server 5.6 解压版安装配置 MySQL Server 5.6 解压版安装配置](https://image.shishitao.com:8440/aHR0cDovL2ltYWdlczIwMTUuY25ibG9ncy5jb20vYmxvZy84NDE0MTIvMjAxNTExLzg0MTQxMi0yMDE1MTEyMTAwNDAwOTA0Ni0xNjgyNTg0MzA3LnBuZw%3D%3D.png?w=700&webp=1)
⑥输入net start mysql回车
![MySQL Server 5.6 解压版安装配置 MySQL Server 5.6 解压版安装配置](https://image.shishitao.com:8440/aHR0cDovL2ltYWdlczIwMTUuY25ibG9ncy5jb20vYmxvZy84NDE0MTIvMjAxNTExLzg0MTQxMi0yMDE1MTEyMTAwNDUxNzQ1Mi0xNjUzMjQ5MDk4LnBuZw%3D%3D.png?w=700&webp=1)
⑦输入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;