root @ localhost → 「編輯權限」→ 「變更密碼」config.inc.php:
$cfg['Servers'][$i]['password'] = 'NewStrongPass123!';
-- 登入 phpMyAdmin SQL 頁籤或命令列
UPDATE mysql.user SET authentication_string = PASSWORD('NewPass123!') WHERE User = 'root';
FLUSH PRIVILEGES;
MySQL 8.0 請用:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPass123!';
# 首次設定密碼(預設空密碼)
mysqladmin -u root password 'NewPass123!'
# 已有密碼時修改
mysqladmin -u root -p'OldPass' password 'NewPass123!'
# 1. 停止服務
systemctl stop mysqld
# 2. 跳過權限啟動
mysqld_safe --skip-grant-tables --skip-networking &
# 3. 免密登入修改
mysql -u root
UPDATE mysql.user SET authentication_string = PASSWORD('NewPass123!') WHERE User='root';
FLUSH PRIVILEGES;
# 4. 正常重啟
mysqladmin -u root -p'NewPass123!' shutdown
systemctl start mysqld
修改 root 密碼後,必須同步修改 phpMyAdmin/config.inc.php:
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // 建議用 cookie 認證,不寫死密碼
// 若用 config 認證模式,必須更新:
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'NewStrongPass123!';
否則 phpMyAdmin 會提示「無法連線 MySQL 伺服器」。
validate_password 元件強制強度