MySQL安装教程及配置环境变量（建议收藏）

梦里梦外; 2023-10-03 11:57 20阅读 0赞

### MySQL安装教程 ###

--------------------

**下载安装：**

官网下载地址：http://dev.mysql.com/downloads/mysql/

选择适配并下载：![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center]

选择第一个

1、解压

2、把这个解压包放置自己的电脑环境目录

--------------------

**配置环境变量：**

3、打开我们的电脑（选择属性）![在这里插入图片描述][af637bb44f974532bb94a870b8a6049a.png_pic_center]

4、选择高级系统设置

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 1]

5、选择环境变量

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 2]

6、选择Path，点击新建

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 3]

7、打开MySQL包，点击bin目录，选择并复制

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 4]

8、复制入新建中

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 5]

9、最后点击确定！

--------------------

**新建mysql配置文件：**

10、后缀为.ini

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 6]

11、

[mysqld]
    basedir=D:\MySQL\mysql-8.0.26-winx64\mysql-8.0.26-winx64
    datadir=D:\MySQL\mysql-8.0.26-winx64\mysql-8.0.26-winx64\data\
    port=3306
    wait_timeout=31536000
    interactive_timeout=31536000
    #skip-grant-tables
    #character-set-server=utf8
    #LOG-BIN-trust-FUNCTION-creators=1

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 7]

12、启动管理员模式下的CMD，运行所有的命令

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 8]

13、启动**管理员**模式下的CMD，输出cd /d E:\\MySQL\\mysql-8.0.26-winx64

13、并将路径切换至mysql下的bin目录，然后输入mysqld –install (安装mysql)

14、再输入 mysqld --initialize-insecure --user=mysql 初始化数据文件

然后再次启动mysql 然后用命令 mysql –u root –p 进入mysql管理界面（密码可为空）

15、进入界面后更改root密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

16、刷新权限

flush privileges;

17、修改 my.ini文件删除最后一句skip-grant-tables ，再skip-grant-tables 前面加\#

18、重启mysql即可正常使用

net stop mysql
     net start mysql

es ，再skip-grant-tables 前面加\#

19、连接上测试出现以下结果就安装好了

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center]: https://img-blog.csdnimg.cn/a11e7b8d5bde4d2ca4f9ca022b3c177b.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ==,size_16,color_FFFFFF,t_70#pic_center
[af637bb44f974532bb94a870b8a6049a.png_pic_center]: https://img-blog.csdnimg.cn/af637bb44f974532bb94a870b8a6049a.png#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 1]: https://img-blog.csdnimg.cn/7fc14ab069b64d1a85b20909c3cd6b33.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ==,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 2]: https://img-blog.csdnimg.cn/56e03f1bd1d04ae291563df3ac0f2aa6.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ==,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 3]: https://img-blog.csdnimg.cn/567860af88f14ffda3908e3d8e713347.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ==,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 4]: https://img-blog.csdnimg.cn/04d60543346f4993b281bcc33d75638e.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ==,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 5]: https://img-blog.csdnimg.cn/a5571e2eb0464e04b5153e27e81ed53a.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ==,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 6]: https://img-blog.csdnimg.cn/f43ff18eab634be29058c9f44efc4b7f.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ==,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 7]: https://img-blog.csdnimg.cn/3c4009410e894ccbab54f6ef6b82d67d.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ==,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ_size_16_color_FFFFFF_t_70_pic_center 8]: https://img-blog.csdnimg.cn/ef45abbdbd4046a98a1970f61175230f.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl81MDU2OTc4OQ==,size_16,color_FFFFFF,t_70#pic_center