mysql -u root -p
USE mysql;
SELECT host, user FROM user;
-- 僅顯示 localhost,無 %
-- 允許任意 IP 以密碼 password 連線
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
-- 或限定特定 IP
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.104' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
SELECT host, user FROM user;
-- 應出現 % | root 和 % | myuser
# 遠程機器測試
mysql -h 目標IP -u root -p
# 出現 mysql> 即成功
mysql.db 表記錄用戶對特定資料庫的權限,多用戶環境建議配合 GRANT ... ON db.* 限定庫級權限,避免全域 *.* 風險。
REQUIRE SSL。mysql.user、mysql.db 權限表。