命令列 mysql -u root -p 可正常登入,但 phpMyAdmin 返回 #1130 - Host 'xxx' is not allowed to connect to this MySQL server。

MySQL 使用者帳號綁定 Host 欄位,預設 root@localhost 僅允許本機 Unix Socket 連線。phpMyAdmin 透過 TCP/IP (127.0.0.1 或 ::1) 連線,Host 不匹配導致拒絕。
mysql -u root -pUSE mysql;SELECT Host, User FROM user WHERE User='root';% (允許任意主機) 或具體 IP:
UPDATE user SET Host='%' WHERE User='root' AND Host='localhost'; FLUSH PRIVILEGES;
SELECT Host, User FROM user WHERE User='root';service mysql restart生產環境嚴禁使用
root@%! 應建立專用應用帳號、限制來源 IP、強制 SSL 連線:CREATE USER 'app_user'@'10.0.0.%' IDENTIFIED BY 'StrongPassw0rd!'; GRANT SELECT,INSERT,UPDATE,DELETE ON app_db.* TO 'app_user'@'10.0.0.%'; REQUIRE SSL; FLUSH PRIVILEGES;
CREATE USER 'root'@'127.0.0.1' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION; FLUSH PRIVILEGES;
此法僅允許本機 TCP 連線,相對較安全。
重新整理 phpMyAdmin 登入頁,應可正常登入。