下载
进入官网下载：https://dev.mysql.com/downloads/mysql/
百度网盘资源：
链接：https://pan.baidu.com/s/1dNFDFmuJ5P–5GVMcjFMNw?pwd=t66y
提取码：t66y
安装、配置
- 解压已经下载好的 .zip 安装包到 c 盘，我是放到
C:\Program Files\下 - 在左下角中输入 cmd 后点击
以管理员身份运行 - 在 cmd 窗口中使用命令行
$ cd C:\Program Files\mysql-8.0.29-winx64\bin进行 bin 目录 - 使用以下命令行初始化数据库，然后记录随机生成的 root 用户密码 bJvW,tgO9n6M
1 2 3 4 5
$ mysqld --initialize --console initializing of server in progress as process 22388 2022-06-07T12:21:53.160001Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-06-07T12:21:53.681532Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2022-06-07T12:21:55.229123Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: bJvW,tgO9n6M
- 使用以下命令行将 mysql 安装为 windows 的服务
1 2
$ mysqld -install Service successfully installed.
- 启动 mysql 服务
1 2 3
$ net start mysql MySQL 服务正在启动 . MySQL 服务已经启动成功。
- 登录数据库，使用之前记录的密码
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
$ 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.29 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>
- 登录成功后修改密码
1 2 3 4
mysql>alter user 'root'@'localhost' identified by '想要设置的密码'; Query OK, 0 rows affected (0.01 sec) mysql>commit; Query OK, 0 rows affected (0.00 sec)
- 退出数据库
1 2
mysql>quit; Bye
- 停止服务
1
$ net stop mysql
