# 首次給 root 設密碼
mysqladmin -u root password 'newpass'
# 已有密碼時修改
mysqladmin -u root -p'oldpass' password 'newpass'
mysql -u root -p
UPDATE mysql.user SET Password = PASSWORD('newpass') WHERE User = 'root';
FLUSH PRIVILEGES;
mysql -u root -p
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
-- 或當前用戶
SET PASSWORD = PASSWORD('newpass');
FLUSH PRIVILEGES;
| 版本 | 密碼欄位 | 推薦語法 |
|---|---|---|
| 5.6 / 5.7 | Password (CHAR 41) | SET PASSWORD / ALTER USER |
| 8.0 | authentication_string | ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpass'; |
MySQL 5.7+ 棄用
PASSWORD()函數,8.0 移除。統一使用ALTER USER。
systemctl stop mysqldmysqld_safe --skip-grant-tables --skip-networking &mysql -u root
FLUSH PRIVILEGES;
-- 5.7/8.0
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPass123!';
-- 5.6
UPDATE mysql.user SET Password=PASSWORD('NewPass123!') WHERE User='root';
FLUSH PRIVILEGES;
systemctl restart mysqldUPDATE mysql.user SET Host='localhost' WHERE User='root';