mysqladmin 命令列mysqladmin -u root -p password '新密碼'
# 輸入舊密碼後生效
-- 方式 A: SET PASSWORD
SET PASSWORD FOR 'root'@'%' = PASSWORD('新密碼');
-- 方式 B: UPDATE user 表
USE mysql;
UPDATE user SET Password=PASSWORD('新密碼') WHERE User='root';
FLUSH PRIVILEGES;
-- 方式 C: GRANT ... IDENTIFIED BY (不需 PASSWORD())
GRANT USAGE ON *.* TO 'root'@'%' IDENTIFIED BY '新密碼';
net stop mysqlmysqld --skip-grant-tablesmysqladmin -u root flush-privileges password "新密碼"mysqladmin -u root -p shutdown (輸入新密碼關閉)killall -TERM mysqldmysqld_safe --skip-grant-tables &mysqladmin -u root flush-privileges password "新密碼"user 表恢復密碼data/mysql/user.* (frm, MYD, MYI)。chown -R mysql:mysql /var/lib/mysql/mysql/user.*chmod 600 /var/lib/mysql/mysql/user.*FLUSH PRIVILEGES。DELETE FROM user WHERE User='';DELETE FROM user WHERE Host='%';FLUSH PRIVILEGES;user.MYD(不建議常規使用)直接用 Hex Editor 修改加密雜湊值,風險極高且版本相容性差,僅作緊急備案參考。
validate_password 外掛強制複雜度。