Windows下的mysql解压包安装

雨点打透心脏的1/2处 2022-05-19 11:35 239阅读 0赞

\#\#\#\#\# 1. 下载

我下载的是64位系统的zip包：  
下载地址：\[https://dev.mysql.com/downloads/mysql/\](https://dev.mysql.com/downloads/mysql/)  
下载zip的包：  
 !\[\](https://upload-images.jianshu.io/upload\_images/18154391-1719885b5ce104e2?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)  
!\[\](https://upload-images.jianshu.io/upload\_images/18154391-e2df8cd821fa1e32.gif?imageMogr2/auto-orient/strip)

下载后解压：  
!\[\](https://upload-images.jianshu.io/upload\_images/18154391-ca33aaa9b67f4284.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)

\#\#\#\#\# 2. 配置环境变量

变量名：MYSQL\_HOME  
变量值：D:\\develop\\mysql-5.7.20-winx64\\mysql-5.7.20-winx64  
!\[\](https://upload-images.jianshu.io/upload\_images/18154391-ea091a473f13a28a.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)  
path里添加：%MYSQL\_HOME%\\bin;

\#\#\#\#\# 3. 生成data文件  
\*\*以管理员身份运行cmd\*\*  
进入D:\\develop\\mysql-5.7.20-winx64\\mysql-5.7.20-winx64\\bin 下执行命令：  
mysqld --initialize-insecure --user=mysql   
执行完毕，会在D:\\develop\\mysql-5.7.20-winx64\\mysql-5.7.20-winx64目录下生成data目录

\#\#\#\#\# 4. 安装MySQL服务  
进入bin目录下，执行命令：mysqld -install   
如果发现服务已存在，则卸载原来的服务，执行命令：mysqld -remove MySQL  
再次执行install安装命令  
!\[\](https://upload-images.jianshu.io/upload\_images/18154391-09ff0f2b2c1c1c4b.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)

\#\#\#\#\# 5. 启动MySQL服务  
执行命令：net start mysql  启动mysql服务  
!\[\](https://upload-images.jianshu.io/upload\_images/18154391-63ee8b5b440e3488.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)

\#\#\#\#\# 6. 登录MySQL  
登录mysql:(因为之前没设置密码，所以密码为空，不用输入密码，直接回车即可）  
执行命令：  
C:\\Windows\\system32>mysql -u root -p  
!\[\](https://upload-images.jianshu.io/upload\_images/18154391-8595749c652b2145.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)  
\#\#\#\#\# 7. 查询用户密码

查询用户密码命令：  
mysql> select host,user,authentication\_string from mysql.user;  
!\[\](https://upload-images.jianshu.io/upload\_images/18154391-a2531eafe17c60e5.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)

\#\#\#\#\# 8. 设置(修改)root用户密码  
执行命令：  
mysql> update mysql.user set authentication\_string=password("123456") where user="root";  
此处引号中的内容是密码，自己可以随便设置  
!\[\](https://upload-images.jianshu.io/upload\_images/18154391-012984c70caa9c33.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)  
使设置生效，执行命令：  
mysql> flush privileges;    
!\[\](https://upload-images.jianshu.io/upload\_images/18154391-fac0e1e82ea540e5.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)  
作用：相当于保存，执行此命令后，设置才生效，若不执行，还是之前的密码不变  
\#\#\#\#\# 9.验证  
退出命令:quit,重新登录：  
!\[\](https://upload-images.jianshu.io/upload\_images/18154391-43c7e03e1bd612ee.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)  
至此，Windows下的mysql解压包安装完成。