/usr/local/webserver/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'admin'@'localhost' (using password: YES)'
核心原因:**帳號或密碼錯誤**,或該帳號無 localhost 連線權限。
# 方法 1:SET PASSWORD(需登入後執行)
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');
# 方法 2:UPDATE user 表
USE mysql;
UPDATE user SET Password = PASSWORD('newpassword') WHERE User = 'root';
FLUSH PRIVILEGES;
--skip-grant-tables 啟動:mysqld_safe --skip-grant-tables &mysql -u root| 指令 | 說明 |
|---|---|
mysqladmin -u root -p password 'newpass' | 命令列互動式修改,會提示舊密碼 |
SET PASSWORD FOR 'user'@'host' = PASSWORD('pass'); | SQL 標準語法,適用 5.7+ |
ALTER USER 'user'@'host' IDENTIFIED BY 'pass'; | MySQL 5.7.6+ / 8.0 推薦語法 |
GRANT USAGE ON *.* TO 'user'@'host' IDENTIFIED BY 'pass'; | 舊版相容寫法 |
PASSWORD() 函式已移除,必須用 ALTER USER 或 SET PASSWORD ... = 'hash'caching_sha2_password,舊版客戶端可能需建立 mysql_native_password 帳號bind-address 設為 127.0.0.1 導致外部無法連線host 欄位不是 localhost 或 %原始來源:www.111cn.net