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\binD:\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.25Copyright (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 - GPLCopyright (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>
