win11 mysql8 server的安装与删除

• 一、安装mysql8 server8.0.29

• 解压缩mysql-8.0.29-winx64.zip到C盘根目录

• 在解压缩目录中，新建一个data文件夹

• 在解压缩目录中，新建my.ini文件

• 打开windows终端(管理员)

• 进入mysql解压缩目录下的bin目录

• 添加mysql服务，这里服务名称为mysql8

• PS C:\mysql-8.0.29-winx64\bin> .\mysqld --install mysql8
  Service successfully installed.
  PS C:\mysql-8.0.29-winx64\bin>
  

• 初始化mysql，初始化时会生成一个临时密码，一定记住，这里为 YQmp6v-UuiHr

• PS C:\mysql-8.0.29-winx64\bin> .\mysqld --initialize --console
  2022-07-08T09:51:34.443026Z 0 [System] [MY-013169] [Server] C:\mysql-8.0.29-winx64\bin\mysqld.exe (mysqld 8.0.29) initializing of server in progress as process 6664
  2022-07-08T09:51:34.469687Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
  2022-07-08T09:51:34.788352Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
  2022-07-08T09:51:35.415000Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: YQmp6v-UuiHr
  PS C:\mysql-8.0.29-winx64\bin>
  

• 启动mysql

• PS C:\mysql-8.0.29-winx64\bin> net start mysql8
  mysql8 服务正在启动 .
  mysql8 服务已经启动成功。
  
  PS C:\mysql-8.0.29-winx64\bin>
  

• 登录mysql，输入上面临时产生的密码

• PS C:\mysql8.0.22\bin> .\mysql -uroot -p
  Enter password: ************
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 8
  Server version: 8.0.22
  
  Copyright (c) 2000, 2020, 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>
  

• 修改密码为123456，退出mysql重新进入

• mysql> alter user 'root'@'localhost' identified by '123456';
  Query OK, 0 rows affected (0.01 sec)
  
  mysql> set password for root@localhost = '123456';
  Query OK, 0 rows affected (0.01 sec)
  
  mysql>
  

• 退出mysql，并重新以123456登录

• PS C:\mysql-8.0.29-winx64\bin> .\mysql -uroot -p
  Enter password: ******
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 10
  Server version: 8.0.29 MySQL Community Server - GPL
  
  Copyright (c) 2000, 2022, 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>
  

• 二、删除mysql8

• 停止mysql8服务

• PS C:\mysql-8.0.29-winx64\bin> net stop mysql8
  mysql8 服务正在停止.
  mysql8 服务已成功停止。
  
  PS C:\mysql-8.0.29-winx64\bin>
  

• 删除mysql8服务

  • 方法1

  • sc delete mysql8
    

  • 方法2

    • 打开注册表（win+r，输入regedit）
    • 找到 HKEY_LOCAL_MACHINE->SYSTEM->CurrentControlSet->Services->mysql8，将其删除，然后重启电脑

  • 注：我在win11下使用方法1无法删除服务名

• 删除mysql对应的解压缩目录