windows安装启动mysql8.0版本的简单流程

1.下载mysql8.0.25版本

MySQL :: Download MySQL Community Server (Archived Versions)

2.解压到D盘的mysql文件夹,并修改环境变量

配置环境变量: win+r键=>输入control system=>高级系统设置=>点击环境变量

双击path后,新建

将bin目录粘贴进去,再点击确定

在cmd命令行查看mysql版本,如果正常显示,说明环境变量设置成功

C:\Users\MSI_NB>mysql --version
mysql  Ver 8.0.25 for Win64 on x86_64 (MySQL Community Server - GPL)

3.使用管理员权限打开cmd,安装并启动mysql服务

注意: 如果不使用管理员权限,无法install和启动服务

mysqld install会报错: Install/Remove of the Service Denied!

C:\Windows\System32>d:

D:\>cd D:\mysql\mysql-8.0.25-winx64\bin

D:\mysql\mysql-8.0.25-winx64\bin>mysqld --initialize --console
2024-07-12T04:15:50.877834Z 0 [System] [MY-013169] [Server] D:\mysql\mysql-8.0.25-winx64\bin\mysqld.exe (mysqld 8.0.25) initializing of server in progress as process 38152
2024-07-12T04:15:50.889754Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-12T04:15:51.283715Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-12T04:15:52.121236Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: wwfZVhP(e8B;
// 记住上面控制台显示的临时密码: wwfZVhP(e8B;
// 不要死记,要看自己的控制台显示的是什么!

// 安装mysqld服务
D:\mysql\mysql-8.0.25-winx64\bin>mysqld install
Service successfully installed.

// 启动mysql
D:\mysql\mysql-8.0.25-winx64\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。


// 使用临时密码登录mysql,并修改密码为123456
D:\mysql\mysql-8.0.25-winx64\bin>mysql -uroot -hlocalhost -p"wwfZVhP(e8B;"
mysql: [Warning] Using a password on the command line interface can be insecure.
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> alter user user() identified by "123456";
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

// 验证新密码是否能够登录mysql
D:\mysql\mysql-8.0.25-winx64\bin>mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.25 MySQL Community Server - GPL

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>