MySQL下载与安装

淩亂°似流年 2023-01-02 01:24 174阅读 0赞

## MySQL下载与安装 ##

**一、下载**

1.  地址：[https://dev.mysql.com/downloads/mysql/][https_dev.mysql.com_downloads_mysql]
2.  当前最新是8.0版本，我选择上一个最新的mysql-5.7.24-winx64.zip  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70]  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 1]  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 2]

**二、安装**

1.  MySQL安装文件分两种 .msi和.zip ，.msi需要安装  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 3]
2.  zip格式是自己解压，解压缩之后其实MySQL就可以使用了，但是要进行环境变量配置zip格式是自己解压
3.  我的电脑->属性->高级->环境变量  
    选择Path,在其后面添加: 你的mysql bin文件夹的路径 ：  
    F:\\mysql\\mysql-5.7.24-winx64\\mysql-5.7.24-winx64\\bin;  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 4]
4.  配置完环境变量之后，在F:\\mysql\\mysql-5.7.24-winx64\\mysql-5.7.24-winx64目录下新增加一个配置文件mysql.ini ，同时在bin的同级目录下创建一个data文件夹（用于存放数据库数据）  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 5]
5.  mysql.ini文件的内容如下

[mysql]
    
    # 设置mysql客户端默认字符集
    default-character-set=utf8 
    
    [mysqld]
    
    #设置3306端口
    port = 3306 
    
    # 设置mysql的安装目录
    basedir=F:\mysql\mysql-5.7.24-winx64\mysql-5.7.24-winx64
    
    # 设置mysql数据库的数据的存放目录
    datadir=F:\mysql\mysql-5.7.24-winx64\mysql-5.7.24-winx64\data
    
    # 允许最大连接数
    max_connections=200
    
    # 服务端使用的字符集默认为8比特编码的latin1字符集
    character-set-server=utf8
    
    # 创建新表时将使用的默认存储引擎
    default-storage-engine=INNODB

*  1
 *  2
 *  3
 *  4
 *  5
 *  6
 *  7
 *  8
 *  9
 *  10
 *  11
 *  12
 *  13
 *  14
 *  15
 *  16
 *  17
 *  18
 *  19
 *  20
 *  21
 *  22
 *  23
 *  24

1.  打开cmd，不需要进入安装目录（∵之前配置过环境变量），输入下面命令，回车，没有反应

mysqld --initialize-insecure --user=mysql

*  1

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

1.  输入下面命令，回车，会提示安装成功

mysqld install

*  1

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

1.  启动服务，输入如下命令，回车，启动成功后如下图

net start mysql

*  1

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

1.  服务启动成功之后，需要登录的时候输入命令（第一次登录没有密码，直接按回车过）

mysql -u root -p

*  1

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 9]

1.  修改密码（必须先启动mysql），执行如下命令回车，enter password也回车，密码一般设置为root，方便记忆

mysqladmin -u root -p password

*  1

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 10]

1.  退出exit 就行了，记住直接关闭cmd窗口是没有退出的，要输入exit才会退出啊  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 11]

## 关闭mysql开机自启动 ##

1.  在运行中输入Services.msc  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 12]
2.  mysql右键属性，自动改成手动  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 13]

**三、Navicat图形化界面连接mysql**

1.  新建连接  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 14]
2.  填写连接ip和密码  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 15]
3.  查看是否连通  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 16]  
    出现如下状况的原因：没有启动mysql  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 17]

[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70]: /images/20221120/4f3d687b86c1456c9f571951a44218d9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 1]: /images/20221120/9642c662d69e40ac8429d617cdb73bdc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 2]: /images/20221120/c35a81c3e8064db1954822b3c032820a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 3]: /images/20221120/3d7489018b1e462db8ac86063b9771e3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 4]: /images/20221120/0afb4553e72a4f4889958e3b5f8a957c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 5]: /images/20221120/61238a709fa04603bea4a205c9a244ab.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 6]: /images/20221120/a606137cc0e14fcca6e3aa10f0197231.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 7]: /images/20221120/ad857fa965f940fd98c2d7fa62159819.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 8]: /images/20221120/e7d7d07659384a659ade14467b4e952d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 9]: /images/20221120/5f3a5a2cb948467b9890ebcf452bd170.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 10]: /images/20221120/94b5c5899a974d02a52405d05de6892a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 11]: /images/20221120/6f294f4e3f6e454e97050b4d7ef230c0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 12]: /images/20221120/0f4f974d7dd34d929340ef3ef5d73d2e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 13]: /images/20221120/4a36835e7eb34830b6a3a9e4299a2dc6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 14]: /images/20221120/bb0840526dbb4e32b518a94cfa793cde.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 15]: /images/20221120/7ced82c007da4b33a5d632163c041f4c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 16]: /images/20221120/0a006bb848c445dfaee90d70b7153863.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg2OTM2NQ_size_27_color_FFFFFF_t_70 17]: /images/20221120/b25cf460d6d14379ba188e82806c2f29.png