MySQL安装以及配置环境手把手教程

╰半夏微凉° 2024-02-05 11:27 16阅读 0赞

### `sql`安装使用流程 ###

1.  官网https://dev.mysql.com/downloads/mysql/ 下载对应Windows zip

![image-20231203205557349][]

![image-20231203205611840][]

2.安装解压到你所设定的文件路径

![image-20231203205732968][]

**我的在C盘 Program FIle路径**

3.配置mysql环境变量

*  在mysql-8.0.22-winx64目录里面找到bin文件所在目录
 *  ![image-20231203205949794][]
 *  ![image-20231203210013607][]
 *  在`此电脑`右击鼠标选择属性–>点击`高级系统设置`–>点击`环境变量(N)`–>在`系统变量(S)`中找到`Path`变量
    
    —>点击`Path`,选择`编辑(I)`–>把`bin`目录的地址复制在里面–>点击确定,完成
 *  ![image-20231203210114668][]
 *  ![image-20231203210217149][]
 *  ![image-20231203210246169][]
 *  ![image-20231203210509812][]
 *  ![image-20231203210648380][]

4.mysql初始化和启动

使用管理员的身份运行`cmd`

*  ![image-20231203210915099][]
 *  由于配置好了环境变量 直接在当前目录输入初始化`MySQL`命令(**如果没有配置环境变量,那么直接找到bin目录输入,如下**)
    
     *  `mysqld --initialize-insecure`
     *  作用初始化数据库,并默认root密码为空
     *  ![image-20231203211137156][]
     *  ![image-20231203211318710][]
     *  命令执行后,在`mysql`安装目录会生成一个data目录,说明初始化成功
     *  ![image-20231203211332664][]
 *  为Windows系统安装`MySQL`服务
    
     *  命令`mysqld install`
     *  作用: 为Windows系统安装`MySQL`服务,默认服务名为`mysql`
     *  输入命令`sc query mysql`,查看一下名为`mysql`的服务
     *  ![image-20231203211556776][]
 *  启动`MySQL`服务
    
     *  命令`sc delete mysql`
     *  作用:启动`MySQL`服务,注意此时的"mysql"表示服务名
     *  
     *  **到此mysql18安装完成!**
     *  **补充:删除服务命令`sc delete mysql`卸载时使用**
     *  ![image-20231203211948510][]
 *  为root账号设置密码
    
     *  上面已经将root账号设置为空,可以使用root用户直接登录,然后修改密码.
     *  修改密码命令`ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你所设置的密码';`
     *  ![image-20231203212247912][]
     *  为了检验是否修改成功 可以刷新重新登录 命令`FLUSH PRIVILEGES;`
     *  **至此设置完工 之后就可以使用相关指令在命令框进行数据库的操作了,也可以下载可视化工具**

[image-20231203205557349]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/287959bb96004525b6cd23a2021a9f00.png
[image-20231203205611840]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/790fa5abc75e448a94bb9a589e5da29e.png
[image-20231203205732968]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/5c6ba03bd12949e49c0d40bd892ba273.png
[image-20231203205949794]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/275c0ead53854801b53f456219a4cbd7.png
[image-20231203210013607]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/9b08b5bbe2ab4a1c99e8b4c1d1cbfcd6.png
[image-20231203210114668]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/b2ca34bb7a14467f8d02f76a50b9ba7b.png
[image-20231203210217149]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/b01c513a484441c3a996404424832031.png
[image-20231203210246169]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/e077f175209c41978969968e210ceb23.png
[image-20231203210509812]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/87142b9f7e894aa2aad30a2222263e12.png
[image-20231203210648380]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/ae314f7bb5664a3bac4cecf5a71fd298.png
[image-20231203210915099]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/777f1f2c6df347e1aa174801979ecad6.png
[image-20231203211137156]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/a87d654acd9c4eb0b9595584ec4fff44.png
[image-20231203211318710]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/deaf1bbef722406aa13a3a24c7b06e78.png
[image-20231203211332664]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/a86ae2068403429abb54d6c95bc5d7f2.png
[image-20231203211556776]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/eca821a895d34d069964521ee49ddaf8.png
[image-20231203211948510]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/75dfad91a49f475e924f22d1a5010d81.png
[image-20231203212247912]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/05/680dd34cbd9e434b9903c903193fea59.png