MySQL的下载安装

梦里梦外; 2023-01-02 01:23 207阅读 0赞

windows下载mysql地址：[https://dev.mysql.com/downloads/installer/][https_dev.mysql.com_downloads_installer] 此下载包括64位

![20181130141154374.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70][]

window安装

打开下载的文件，等弹出窗口

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 1][]

选择类型我选择自定义

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 2][]

这块不懂，网上查的

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 5][]

ok ——> next

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 6][]

等待安装完成

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 7][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 8][]

进入配置

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 9][]

高级选项，可以不选

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 10][]

下图选择默认推荐

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 11][]

添加用户，加不加都行

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 12][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 13][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 14][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 15][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 16][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 17][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 18][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 19][]

安装完成

测试

我使用navicat连接

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 20][]

使用地址为localhost报错

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 21][]

解决方法：

1.  `ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则`
2.  ``
3.  `ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码`
4.  ``
5.  `FLUSH PRIVILEGES; #刷新权限`
6.  
7.  `以上的 'password'为你自己安装时候的密码`
8.  `我没有执行最后一步刷新权限，没出问题，如不放心可执行`

换成本地ip登录

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 22][]

报错提示

![20181130154145393.png][]

解决方法：

执行：mysql>update user set host = '%' where user = 'root';

如果以上两个先解决ip登录问题，再解决localhost的问题的话，要把'root'@'localhost'改成'root'@'%'

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 23][]

安装成功

linux下载mysql地址：[https://dev.mysql.com/downloads/mysql/][https_dev.mysql.com_downloads_mysql]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 24][]

上述页面进行下拉到下图

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 25][]

此图为翻译

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 26][]

安装

检测系统是否自带安装 MySQL:

rpm -qa | grep mysql

如果系统有安装，那可以选择进行卸载:

1.  `rpm -e mysql　　// 普通删除模式`
2.  `rpm -e --nodeps mysql　　// 强力删除模式，如果使用上面命令删除时，提示有依赖的其它文件，则用该命令可以对其进行强力删除`

linux解压下载好的文件 适合gz文件

指令：tar -zxvf mysql-8.0.13.tar.gz

linux解压下载好的文件 适合xz文件

tar xvf mysql-8.0.13.tar.xz 执行完成生成.tar文件

给文件重命名（个人爱好）

指令：mv mysql-8.0.13 mysql

删除文件（个人爱好）

指令：rm -rf mysql-8.0.13.tar.gz

创建data数据库文件目录，位置自选

指令：mkdir data/mysql

创建mysql的用户组

指令：groupadd mysql

创建mysql的用户

指令： useradd mysql -g mysql

进入到mysql文件下

![20181130160005702.png][]

改变目录属有者 注意后面有个点  
指令：chown -R mysql .  
指令：chgrp -R mysql .

指令：chown -R mysql /data/mysql

指令：chgrp -R mysql /data/mysql

安装libaio依赖包，

查询是否暗转libaio依赖包

指令：yum search libaio

如果没安装，可以用下面命令安装

指令：yum install libaio

初始化mysql命令

cd mysql/bin

指令：./mysqld --initialize --user=mysql --basedir=/usr/src/java/mysql/ --datadir=/usr/src/java/data/mysql/

在执行上面命令时特别要注意下面内容

`[Note] A``temporary` `password` `is` `generated``for` `root@localhost: o*s#gqh)F4Ck`

root@localhost: 后面跟的是mysql数据库登录的临时密码，各人安装生成的临时密码不一样

如果mysql5.x初始化出现几个error但是临时密码出来的话应该是可以继续

1.  `如下错误，去data/mysql 里面看看有没有一个.index文件 有的话删了`
2.  
3.  `[Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.`
4.  `2018-12-05T14:26:12.912603Z 0 [System] [MY-013169] [Server] /usr/java/mysql/bin/mysqld (mysqld 8.0.13) initializing of server in progress as process 8833`
5.  `2018-12-05T14:26:12.914331Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.`
6.  `2018-12-05T14:26:12.914370Z 0 [ERROR] [MY-013236] [Server] Newly created data directory /data/mysql/ is unusable. You can safely remove it.`
7.  `2018-12-05T14:26:12.914379Z 0 [ERROR] [MY-010119] [Server] Aborting`

我没有报错，没用到如下内容

1.  `如果初始化时报错如下：`
2.  
3.  `error while loading shared libraries: libnuma.so.1: cannot open shared objec`
4.  
5.  `是因为libnuma安装的是32位，我们这里需要64位的，执行下面语句就可以解决`
6.  
7.  `#yum install numactl.x86_64`
8.  
9.  `执行完后重新初始化mysql命令`

**修改系统配置文件**

指令：cd mysql/support-files

指令： cp mysql.server /etc/init.d/mysql

指令： vi /etc/init.d/mysql

修改以下内容：

修改前

![20181203103450313.png][]

修改后

![20181203101105100.png][]

**启动mysql**

指令：/etc/init.d/mysql start

1.  `mysql：5.7 启动出现的问题`
2.  `mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'.`
3.  
4.  `我们这样解决`
5.  `mkdir /var/log/mariadb`
6.  `touch /var/log/mariadb/mariadb.log`
7.  `chown -R mysql:mysql /var/log/mariadb/`
8.  
9.  
10. `初始化完成之后记得修改以下my.cnf文件`
11. `vi /etc/my.cnf`
12. `把datadir 改成你的data路径 socket路径改成你的mysql路径 在加上一层/mysql.sock`
13. 
14.

![20181203101240394.png][]

如果出现以上错误

原因可能：mysql5.7.21不需要my.cnf文件，所以需要检查/etc目录下是否存在my.cnf文件，若存在需删除，否则启动服务会报错

登陆

指令： mysql -u root -p

--如果出现：-bash: mysql: command not found

--就执行： ln -s /usr/local/mysql/bin/mysql /usr/bin --没有出现就不用执行 红色路径为你自己路径

输入生成的临时密码

1.  `Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)`
2.  `这是可以由于系统默认的文件位置和文件位置不一致,解决办法找到文件创建软链接`
3.  `find / -name mysql.sock`
4.  `ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock`

修改密码

mysql> set password=password('123456'); 在centos7 不好用

mysql8.x使用如下

ALTER USER "root"@"localhost" IDENTIFIED BY "你的新密码"; 这里尽量不要复制，容易乱码出错

设置root账户的host地址（修改了才可以远程连接）

指令：mysql> use mysql; 选择一下表，不然报错

![20181203104140259.png][]

指令：mysql>update user set host = '%' where user = 'root';

指令：mysql>flush privileges;

查看表

指令：mysql> use mysql;  
指令：mysql> select host,user from user;

效果如下

![20181203101918334.png][]

防火墙配置的话我是直接关闭

防火墙关闭：[https://blog.csdn.net/qq\_39900178/article/details/84228428][https_blog.csdn.net_qq_39900178_article_details_84228428]

firewall-cmd --zone=public --add-port=3306/tcp --permanent

service firewalld restart

以上是防火墙放行端口操作

进行navicat远程测试

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 21][]

解决方法：

报错提示

![20181130154145393.png][]

解决方法：

执行：mysql>update user set host = '%' where user = 'root';

如果以上两个先解决ip登录问题，再解决localhost的问题的话，要把'root'@'localhost'改成'root'@'%'

**添加系统路径**  
指令： vim /etc/profile  
添加：  
export PATH=/usr/src/java/mysql/bin:$PATH 也可以把路径直接追加到path后面

刷新

指令：source /etc/profile

**配置mysql自动启动**  
指令： chmod 755 /etc/init.d/mysql  
指令： chkconfig --add mysql  
指令： chkconfig --level 345 mysql on

安装完成

参考链接：[https://www.cnblogs.com/ggwudivs/p/8875799.html?tdsourcetag=s\_pctim\_aiomsg][https_www.cnblogs.com_ggwudivs_p_8875799.html_tdsourcetag_s_pctim_aiomsg]

[https_dev.mysql.com_downloads_installer]: https://dev.mysql.com/downloads/installer/
[20181130141154374.png]: /images/20221120/52a7898bd6514fcaa63286496b958fff.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70]: /images/20221120/190eaec6d45e4726ae6af8a35755e281.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 1]: /images/20221120/891f5fcf677c45788fa17eb2615c365a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 2]: /images/20221120/9f11b81d452c48c7b47ce79fe8c36661.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 3]: /images/20221120/a6180617da8d4ba3a5b19959ba8b5a75.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 4]: /images/20221120/21433971fabc4bbf9de8e18ee5ca2cf5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 5]: /images/20221120/d58832a5454143dbbb44bc1f2fe6d44e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 6]: /images/20221120/8abf87fcbed044b5ad232e53df5e4029.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 7]: /images/20221120/29d504fd0cce4198b1bcf24efab64bd1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 8]: /images/20221120/189b74ca0bdc4c30b303fa9f991942b2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 9]: /images/20221120/b1ca6a114a53427db43b71c3c29de439.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 10]: /images/20221120/3fcec65dfbe343f183edac6481451ac4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 11]: /images/20221120/70937c628e0141a89c3864dc20687e38.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 12]: /images/20221120/26a68db1fc4b4d52897b3823d389ef74.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 13]: /images/20221120/706daf10709f4800bca2e4740cc2926a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 14]: /images/20221120/1ef18046eb6c4559afd524dcf7fda5bb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 15]: /images/20221120/7657505cef214e44bc4a4de4f16beb85.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 16]: /images/20221120/07bea0100bee4f3eb2ab6154b7827647.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 17]: /images/20221120/ce7a0381114f47bebe49063dbf3dc2cf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 18]: /images/20221120/bc03b81fa9cd46ac88e8eac8f23d121b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 19]: /images/20221120/dac822416246447698ddac099069c8b1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 20]: /images/20221120/9c55b7647d074b96b2b9f29bca6a7a4a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 21]: /images/20221120/94f1b2ddb2804ae986fcef348cb64d62.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 22]: /images/20221120/399806c1a4f44a7cbe96fdb605dea537.png
[20181130154145393.png]: /images/20221120/b5d4c80ee2a24c509ec2cf448a9ed87b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 23]: /images/20221120/18600798210c428eb928b9ea1a15efbd.png
[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 24]: /images/20221120/5dfcf26d76ce48c59fc60a8c22fadf3b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 25]: /images/20221120/c48acf61c3db474b94d4bd975483576d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTAwMTc4_size_16_color_FFFFFF_t_70 26]: /images/20221120/076e668fec8648fab654214369fdd2ab.png
[20181130160005702.png]: /images/20221120/14ebc85c8f8546dbb308cade2812eecd.png
[20181203103450313.png]: /images/20221120/20360a24410c455b934a908950d5f9aa.png
[20181203101105100.png]: /images/20221120/97a8a94ad11d49a9ae337372d5dc567c.png
[20181203101240394.png]: /images/20221120/812b8fbb19a5463bbe62743d49562ccf.png
[20181203104140259.png]: /images/20221120/4359fc8d5d0241cbb830dc9b744fb46b.png
[20181203101918334.png]: /images/20221120/77555704b8f84b84bbab82a428cec9bd.png
[https_blog.csdn.net_qq_39900178_article_details_84228428]: https://blog.csdn.net/qq_39900178/article/details/84228428
[https_www.cnblogs.com_ggwudivs_p_8875799.html_tdsourcetag_s_pctim_aiomsg]: https://www.cnblogs.com/ggwudivs/p/8875799.html?tdsourcetag=s_pctim_aiomsg