MySQL5.7.24安装配置（图文超详细教程）

野性酷女 2022-04-03 09:49 330阅读 0赞

1.下载MySQL 我用的是5.7.24  
打开下载链接：[https://dev.mysql.com/downloads/windows/installer/5.7.html][https_dev.mysql.com_downloads_windows_installer_5.7.html]  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70][]  
点击Download进行下载 弹出页面  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 1]  
点击No thanks进行下载  
下载下来的文件名是 mysql-installer-community-5.7.24.0.msi  
双击文件名称进行安装 如果提示如下错误  
![在这里插入图片描述][20181221152427806.png]  
说明.NET4.5.2未安装 需要安装此插件 报错窗口有网址 直接安装即可  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 2]  
安装完毕后 重新打开MySQL安装程序 这个时候就可以顺利进行安装了  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 3]  
勾选I accept 然后 Next  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 4]  
这里我选择的是Custom 自定义的意思 然后Next  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 5]  
根据自己系统的位数进行选择是X64还是X86 点选后 点击中间的箭头  
然后可以选择路径（默认安装的是C盘）  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 6]  
我选择的是D盘 安装路径和数据路径都是D盘 毕竟放到系统盘 万一崩了 数据就没了  
然后点击Next 点击Execute 然后Next  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 7]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 8]  
这个选择默认即可  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 9]  
服务器专用  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 10]  
MySQL端口默认3306 如果没有特殊需求 一般不建议修改 继续Next  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 11]  
设置MySQL密码 建议字母数字加符号 然后Next  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 12]  
这里是服务显示的名称 无特殊需要也不建议修改 继续Next  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 13]  
有些安装的时候会在这个位置卡住不动 然后错误 无法安装 原因是你的数据库版本高 与本系统不适配 那么降低数据库版本 或者升级系统版本 有一次安装数据库就卡在这里 然后降低5.6就可以了  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 14]  
都检测通过后 点击Finish 然后继续Next 最后Finish即安装完成  
2.接下来就是进行配置：  
用Notepad++打开D:\\MySQL\\MySQL Server 5.7下的my.ini文件 主要修改项如下

innodb_flush_log_at_trx_commit=0 （208行）

更改为0

innodb_buffer_pool_size=2G（224行）

数值一般修改为实际内存的一半即可  
修改数据库编码为UTF8

[client] 
    default-character-set=utf8 
    [mysqld]
    character-set-server=utf8

添加完毕后去服务里面重启My SQL  
测试My SQL  
切换到目录D:\\MySQL\\MySQL Server 5.7\\bin下  
运行cmd窗口  
`mysql -uroot -p` 输入密码 然后`status`

D:\MySQL\MySQL Server 5.7\bin>mysql -uroot -p
    Enter password: *********
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 6
    Server version: 5.7.24-log MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> status
    --------------
    mysql  Ver 14.14 Distrib 5.7.24, for Win64 (x86_64)
    
    Connection id:          6
    Current database:
    Current user:           root@localhost
    SSL:                    Not in use
    Using delimiter:        ;
    Server version:         5.7.24-log MySQL Community Server (GPL)
    Protocol version:       10
    Connection:             localhost via TCP/IP
    Server characterset:    utf8
    Db     characterset:    utf8
    Client characterset:    utf8
    Conn.  characterset:    utf8
    TCP port:               3306
    Uptime:                 10 min 17 sec
    
    Threads: 1  Questions: 6  Slow queries: 0  Opens: 108  Flush tables: 1  Open tab
    les: 101  Queries per second avg: 0.009
    --------------
    
    mysql>

最终显示utf8  
MySQL调试完毕

导入数据库  
常用source 命令  
进入mysql数据库控制台  
如 `mysql -uroot -p`

show databases;
    
    mysql>use xxx;

然后使用source命令，后面参数为脚本文件(如这里用到的.sql)

mysql>source D:/xxx.sql

显示导入成功即可

[https_dev.mysql.com_downloads_windows_installer_5.7.html]: https://dev.mysql.com/downloads/windows/installer/5.7.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70]: /images/20220403/b710749492fa4ad4aa72940e9fea0ac9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 1]: /images/20220403/8e3a56684fb74083a48168270ce38e3f.png
[20181221152427806.png]: /images/20220403/fc564ddb0a4048f09a9a5c989884520a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 2]: /images/20220403/57b5c7682a6b47a481ddebb9e44b6cdd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 3]: /images/20220403/708d18ccb9b34a2ca55236f2f71800de.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 4]: /images/20220403/6644c8b7364c4c4abb891ecf767af502.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 5]: /images/20220403/237ca6125f604dd6aefd6486fe06a70e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 6]: /images/20220403/0c487a692a5a441583ed2a6bd3b8a8de.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 7]: /images/20220403/646f43acb1744af59b86952d5007c69d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 8]: /images/20220403/610253b1bc8548668d72cd7b7f494bd8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 9]: /images/20220403/7b2d2f90bf3d4b4d8290da1d638dc4f8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 10]: /images/20220403/d54623ff89144bb2a504ab3f0fd498df.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 11]: /images/20220403/1cc1402a44064f259fcbe167135472c2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 12]: /images/20220403/3cf69e4bceb14ee180fd504b2a262c67.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 13]: /images/20220403/d3a59bc04e1842069a0c99cb07d1e534.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA1MTYwOA_size_16_color_FFFFFF_t_70 14]: /images/20220403/15733549ef8d4e60ab806f59501af250.png