win10安装MySQL5.7.22 32位

蔚落 2022-12-09 11:58 193阅读 0赞

**目录**

一、环境准备

二、配置文件

三、配置环境变量

四、验证版本

五、命令行安装

六、重置密码

七、允许远程登录

八、防火墙开启端口

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

### 一、环境准备 ###

官网下载地址：[https://downloads.mysql.com/archives/community/][https_downloads.mysql.com_archives_community]

mysql-5.7.22-win32.zip：[https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.22-win32.zip][https_cdn.mysql.com_archives_mysql-5.7_mysql-5.7.22-win32.zip]

mysql-5.7.22-win64.zip：[https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.22-winx64.zip][https_downloads.mysql.com_archives_get_p_23_file_mysql-5.7.22-winx64.zip]

64位和32位安装步骤一致

### 二、配置文件 ###

这里解压到 D:\\MySQL 目录

my.ini 文件内容如下：

[mysqld]
    port=3306
    basedir=D:\MySQL\mysql-5.7.22-win32
    datadir=D:\MySQL\mysql-5.7.22-win32\data
    
    explicit_defaults_for_timestamp=true
    character-set-server=utf8
    default-storage-engine=INNODB
    sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    ## sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    
    max_connections=1000
    max_allowed_packet=8G
    tmp_table_size=16G
    max_heap_table_size=12G
    
    [mysql]
    default-character-set=utf8
    ## default-collation=utf8_general_ci

### 三、配置环境变量 ###

![20200922153044796.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70][]

### 四、验证版本 ###

mysql -V

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 1][]

### 五、命令行安装 ###

右击我的电脑，选择 命令提示符（管理员）

mysqld --initialize

mysqld -install

> The service already exists!  
> The current server installed: D:\\MySQL\\mysql-5.7.22-win32\\bin\\mysqld MySQL

如果出现以上报错，使用管理员身份执行以下命令

sc query mysql  ::查看mysql服务
    sc delete mysql ::删除mysql服务
    mysqld -install ::安装mysql服务

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 2][]

net start mysql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 3][]

### 六、重置密码 ###

在日志文件D:\\MySQL\\mysql-5.7.22-win32\\data\\AlEinstein.err 查看自动生成的密码，使用临时密码登录并修改密码

日志文件：配置的 /data 目录下的 .err后缀的 文件 user 指用户名或电脑名

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 4][]

mysql -uroot -p

set password for root@localhost=password('123456');

### 七、允许远程登录 ###

grant all privileges on *.* to root@'%' identified by '123456';
    flush privileges;

### 八、防火墙开启端口 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 6][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 7][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 8][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 9][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 10][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 11][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 12][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 13][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 14][]

[https_downloads.mysql.com_archives_community]: https://downloads.mysql.com/archives/community/
[https_cdn.mysql.com_archives_mysql-5.7_mysql-5.7.22-win32.zip]: https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.22-win32.zip
[https_downloads.mysql.com_archives_get_p_23_file_mysql-5.7.22-winx64.zip]: https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.22-winx64.zip
[20200922153044796.png]: /images/20221123/f0a79dc7189e4af49c4835984b83cf73.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70]: /images/20221123/546d84b5bcd34f8aa657a35baba112cb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 1]: /images/20221123/198df2bbbc5b431097d51a3374596505.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 2]: /images/20221123/dfc7a80c12994382bdfdce4d03f5024f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 3]: /images/20221123/e133a36f868846e6aee4805bfe6a4502.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 4]: /images/20221123/59fe20b5758947d8867fef57d6ad8f49.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 5]: /images/20221123/22588ed3e05d4af481dacbfa093b4870.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 6]: /images/20221123/26f0ccae8d3143d99fd76f6437a9f922.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 7]: /images/20221123/9e056348c85a4aad9a8c258bc16317a6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 8]: /images/20221123/e6c516bbacae4e42bb3106621ae9e8cf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 9]: /images/20221123/daf1bc68bb0a4995b2fe265e678028e1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 10]: /images/20221123/8e38f63c95c54f59ad0a7ec29f6e4b79.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 11]: /images/20221123/796a0a27e0b4445ca7a4de02a81c42cb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 12]: /images/20221123/0288b6376c2e43e19d068e3ab26315f3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 13]: /images/20221123/26b058830aa146e085140c99388081e1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 14]: /images/20221123/c32929a58f80407c9f7db627f7e38c1e.png