MySQL 修改 root 密碼分兩種情境:知道舊密碼直接改、完全忘記需跳過授權表重置。
mysql -u root -p
-- 登入後執行
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpasswd');
FLUSH PRIVILEGES;
或 5.7.6+ 版本:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpasswd';
systemctl stop mysqld / net stop mysqlmysqld --skip-grant-tables --skip-networking &mysql -u rootUSE mysql;
-- 5.7.5 及之前
UPDATE user SET authentication_string = PASSWORD('newpasswd') WHERE User = 'root' AND Host = 'localhost';
-- 5.7.6+ / 8.0
ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpasswd';
FLUSH PRIVILEGES;
; 1. 停止服務
net stop mysql
; 2. 建立 init 檔 (C:\mysql-init.txt)
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpasswd');
; 3. 啟動並載入 init 檔
mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --init-file=C:\mysql-init.txt
; 4. 正常重啟服務
net start mysql
UPDATE user SET Host='localhost' WHERE User='root';