mysql5.7安装版详细安装教程

Myth丶恋晨 2023-02-20 12:12 8阅读 0赞

### **一、去官网下载自己想要的版本，[https://dev.mysql.com/downloads/mysql/][https_dev.mysql.com_downloads_mysql]。** ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70][]

### **二、选择合适自己系统以及版本下载。** ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 1][]

### **三、解压下载好的文件到自己想安装的目录下。** ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 2][]

### **四、打开解压好的文件，并创建一个my.ini文件，填写以下配置信息，路径根据自己目录修改。因为这个文件5.7版本需要自己创建。** ###

\[mysqld\]  
port = 3306  
basedir=D:\\download\_tools\\mysqlService\\mysql-5.7.29-winx64  
datadir=D:\\download\_tools\\mysqlService\\mysql-5.7.29-winx64/data   
max\_connections=200  
character-set-server=utf8  
default-storage-engine=INNODB  
sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES  
\[mysql\]  
default-character-set=utf8

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 3][]

### **五、配置MYSQL\_HOME环境变量。** ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 4][]

编辑path变量，添加MYSQL\_HOME,注意封号; 最后面是没有封号的，然后依次点击确定。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 5][]

![20200626181656699.png][]

### **六、 需要以系统管理员身份打开cmd运行。在切换到安装目录下，D:\\download\_tools\\mysqlService\\mysql-5.7.29-winx64\\bin ** ###

### **然后执行mysqld -install 命令进行安装，别漏了命令中的d** ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 6][]

### ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 7][]   七、执行mysqld --initialize-insecure --user=mysql命令初始化 ，成功后会在安装目录下生成data目录，并生成root用户。如果报错请手动创建data目录。 ###

![20200626183541894.png][]

### **八、执行net start mysql 命令启动mysql** ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 8][]

### **九、启动成功后，执行 mysqladmin -u root -p password 新密码  命令设置密码，root旧密码为空，执行命令后直接回车。** ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 9][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 10][]

### **到此安装完成。** ###

[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200626175910701.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200626180203591.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200626180500130.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/2020062618105666.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200626181435140.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200626181543414.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz,size_16,color_FFFFFF,t_70
[20200626181656699.png]: https://img-blog.csdnimg.cn/20200626181656699.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20200626182415490.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20200626182927711.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz,size_16,color_FFFFFF,t_70
[20200626183541894.png]: https://img-blog.csdnimg.cn/20200626183541894.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20200626183705813.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/20200626183924514.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz_size_16_color_FFFFFF_t_70 10]: https://img-blog.csdnimg.cn/20200626184007431.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzNzY3MzUz,size_16,color_FFFFFF,t_70