MySQL 8 压缩包版（zip）安装

￡神魔★判官ぃ 2023-01-20 10:59 10阅读 0赞

1.  最新版下载网址：[https://dev.mysql.com/downloads/mysql/][https_dev.mysql.com_downloads_mysql]
2.  历史版本下载网址：[https://downloads.mysql.com/archives/community/][https_downloads.mysql.com_archives_community]
3.  解压安装包：  
    解压目录：
    
        D:\Program Files\mysql-8.0.25-winx64
    
     
4.  增加配置文件 my.ini：  
    官方文档：[https://dev.mysql.com/doc/refman/8.0/en/windows-create-option-file.html][https_dev.mysql.com_doc_refman_8.0_en_windows-create-option-file.html]  
      
    D:/Program Files/mysql-8.0.25-winx64/my.ini
    
        [mysqld]
        # set basedir to your installation path
        basedir=D:\Program Files\mysql-8.0.25-winx64
        # set datadir to the location of your data directory
        datadir=D:\ProgramData\MySQL-8.0.25-Data
5.  初始化数据库：  
    官方文档：[https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html][https_dev.mysql.com_doc_refman_8.0_en_data-directory-initialization.html]
    
    1.  无密码初始化：
        
            mysqld --initialize-insecure --user=mysql --console
        
         
        
            Microsoft Windows [版本 10.0.19042.964]
            (c) Microsoft Corporation。保留所有权利。
            
            D:\Program Files\mysql-8.0.25-winx64\bin>mysqld --initialize-insecure --user=mysql --console
            2021-05-12T12:09:25.071351Z 0 [System] [MY-013169] [Server] D:\Program Files\mysql-8.0.25-winx64\bin\mysqld.exe (mysqld 8.0.25) initializing of server in progress as process 15960
            2021-05-12T12:09:25.080631Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
            2021-05-12T12:09:25.854184Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
            2021-05-12T12:09:27.296992Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
            
            D:\Program Files\mysql-8.0.25-winx64\bin>
        
        翻译：
        
            Microsoft Windows [版本 10.0.19042.964]
            (c) Microsoft Corporation。保留所有权利。
            
            D:\Program Files\mysql-8.0.25-winx64\bin>mysqld --initialize-insecure --user=mysql --console
            2021-05-12T12:09:25.071351Z 0 [System] [MY-013169] [Server] D:\Program Files\mysql-8.0.25-winx64\bin\mysqld.exe (mysqld 8.0.25) 正在将服务器初始化为进程15960
            2021-05-12T12:09:25.080631Z 1 [System] [MY-013576] [InnoDB] InnoDB 初始化已开始。
            2021-05-12T12:09:25.854184Z 1 [System] [MY-013577] [InnoDB] InnoDB 初始化已结束。
            2021-05-12T12:09:27.296992Z 6 [Warning] [MY-010453] [Server] root@localhost 是用空密码创建的！请考虑关闭 --initialize-insecure 选项。
            
            D:\Program Files\mysql-8.0.25-winx64\bin>
    2.  随机密码初始化：
        
            mysqld --initialize --user=mysql --console
        
            Microsoft Windows [版本 10.0.19042.964]
            (c) Microsoft Corporation。保留所有权利。
            
            D:\Program Files\mysql-8.0.25-winx64\bin>mysqld --initialize --user=mysql --console
            2021-05-12T12:19:06.540025Z 0 [System] [MY-013169] [Server] D:\Program Files\mysql-8.0.25-winx64\bin\mysqld.exe (mysqld 8.0.25) initializing of server in progress as process 16816
            2021-05-12T12:19:06.551245Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
            2021-05-12T12:19:07.305727Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
            2021-05-12T12:19:09.131024Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: qaXfshWdt9/+
            
            D:\Program Files\mysql-8.0.25-winx64\bin>
        
        翻译：
        
            Microsoft Windows [版本 10.0.19042.964]
            (c) Microsoft Corporation。保留所有权利。
            
            D:\Program Files\mysql-8.0.25-winx64\bin>mysqld --initialize --user=mysql --console
            2021-05-12T12:19:06.540025Z 0 [System] [MY-013169] [Server] D:\Program Files\mysql-8.0.25-winx64\bin\mysqld.exe (mysqld 8.0.25) 正在将服务器初始化为进程16816
            2021-05-12T12:19:06.551245Z 1 [System] [MY-013576] [InnoDB] InnoDB 初始化已开始。
            2021-05-12T12:19:07.305727Z 1 [System] [MY-013577] [InnoDB] InnoDB 初始化已结束。
            2021-05-12T12:19:09.131024Z 6 [Note] [MY-010454] [Server] 将为生成临时密码 root@localhost: qaXfshWdt9/+
            
            D:\Program Files\mysql-8.0.25-winx64\bin>
6.  启动数据库：  
    官方文档：[https://dev.mysql.com/doc/refman/8.0/en/starting-server.html][https_dev.mysql.com_doc_refman_8.0_en_starting-server.html]
    
        mysqld --user=mysql &
7.  连接数据库：  
    官方文档：[https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html][https_dev.mysql.com_doc_refman_8.0_en_default-privileges.html]
    
        mysql -u root -p
    
     
    
        D:\Program Files\mysql-8.0.25-winx64\bin>mysql -u root -p
        Enter password: ************
        Welcome to the MySQL monitor.  Commands end with ; or \g.
        Your MySQL connection id is 8
        Server version: 8.0.25
        
        Copyright (c) 2000, 2021, Oracle and/or its affiliates.
        
        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>
8.  修改密码：  
    官方文档：[https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html][https_dev.mysql.com_doc_refman_8.0_en_default-privileges.html]
    
        ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password';
    
        mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password';
        Query OK, 0 rows affected (0.01 sec)
        
        mysql>
9.  停止数据库（需要密码）：  
    官方文档：[https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html][https_dev.mysql.com_doc_refman_8.0_en_default-privileges.html]
    
        mysqladmin -u root -p shutdown
    
     
    
        D:\Program Files\mysql-8.0.25-winx64\bin>mysqladmin -u root -p shutdown
        Enter password: *************
        
        D:\Program Files\mysql-8.0.25-winx64\bin>
10. 添加环境变量：  
    官方文档：[https://dev.mysql.com/doc/refman/8.0/en/mysql-installation-windows-path.html][https_dev.mysql.com_doc_refman_8.0_en_mysql-installation-windows-path.html]
    
        MYSQL_HOME="D:\Program Files\mysql-8.0.25-winx64"
        Path=%Path%;%MYSQL_HOME%\bin
11. 安装MySQL为Windows服务：  
    官方文档：[https://dev.mysql.com/doc/refman/8.0/en/windows-start-service.html][https_dev.mysql.com_doc_refman_8.0_en_windows-start-service.html]
    
    1.  [][https_dev.mysql.com_doc_refman_8.0_en_windows-start-service.html]在将MySQL作为Windows服务安装之前，如果正在使用以下命令运行当前服务器，则应首先停止它：
        
            mysqladmin -u root -p shutdown
        
         
        
            Microsoft Windows [版本 10.0.19042.964]
            (c) Microsoft Corporation。保留所有权利。
            
            D:\Program Files\mysql-8.0.25-winx64\bin>mysqladmin -u root -p shutdown
            Enter password: *************
            
            D:\Program Files\mysql-8.0.25-winx64\bin>
    2.  将服务器作为服务安装（以管理员身份运行）：
        
            mysqld --install
        
            Microsoft Windows [版本 10.0.19042.964]
            (c) Microsoft Corporation。保留所有权利。
            
            C:\Windows\system32>D:
            
            D:\>cd D:\Program Files\mysql-8.0.25-winx64\bin
            
            D:\Program Files\mysql-8.0.25-winx64\bin>mysqld --install
            Service successfully installed.
            
            D:\Program Files\mysql-8.0.25-winx64\bin>
12. 查看服务：  
    ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyNTk2NTI3_size_16_color_FFFFFF_t_70][]

[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/
[https_downloads.mysql.com_archives_community]: https://downloads.mysql.com/archives/community/
[https_dev.mysql.com_doc_refman_8.0_en_windows-create-option-file.html]: https://dev.mysql.com/doc/refman/8.0/en/windows-create-option-file.html
[https_dev.mysql.com_doc_refman_8.0_en_data-directory-initialization.html]: https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html
[https_dev.mysql.com_doc_refman_8.0_en_starting-server.html]: https://dev.mysql.com/doc/refman/8.0/en/starting-server.html
[https_dev.mysql.com_doc_refman_8.0_en_default-privileges.html]: https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html
[https_dev.mysql.com_doc_refman_8.0_en_mysql-installation-windows-path.html]: https://dev.mysql.com/doc/refman/8.0/en/mysql-installation-windows-path.html
[https_dev.mysql.com_doc_refman_8.0_en_windows-start-service.html]: https://dev.mysql.com/doc/refman/8.0/en/windows-start-service.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyNTk2NTI3_size_16_color_FFFFFF_t_70]: /images/20221021/0bb9fbe404124e40ba99fb46bcfb6c4a.png