問(wèn)題“access denied for user 'root'@'localhost'”通常因未設(shè)置密碼、認(rèn)證方式變更或權(quán)限配置錯(cuò)誤導(dǎo)致，解決方法如下：1. 若未設(shè)置密碼或忘記密碼，可嘗試無(wú)密碼登錄並設(shè)置新密碼，或通過(guò)安全模式重置；2. 若使用新版MySQL/MariaDB，默認(rèn)認(rèn)證方式可能為auth_socket，需修改為mysql_native_password；3. 確保正確連接localhost且具備訪問(wèn)權(quán)限，必要時(shí)使用sudo運(yùn)行客戶端或檢查GUI工具配置；4. 徹底無(wú)法登錄時(shí)可通過(guò)停止MySQL服務(wù)後以--skip-grant-tables模式啟動(dòng)重置密碼。

You're seeing the "access denied for user 'root'@'localhost'" error after a fresh MySQL install because the root user hasn't been properly authenticated or configured yet. This is common, especially if you didn't set a password during installation or if something went wrong in the setup process.

Here are a few key reasons and how to fix them:

1. Root Password Not Set or Forgotten

MySQL doesn't always prompt you to set a root password during installation, especially on some Linux distributions like Ubuntu. If no password was set, trying to log in with one will cause an access denied error.

What to do:

• Try logging in without a password:

   mysql -u root

• If that works, set a password right away:

   ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_password';

If you think you set a password but can't remember it, you'll need to reset it using safe mode (more on that below).

2. Authentication Method Changed

Newer versions of MySQL and MariaDB sometimes use auth_socket or unix_socket authentication by default for the root user, which means it only allows login from the system root user without a password.

How to check:

• Log in without a password as mentioned earlier.
• Run this query:

   SELECT User, Host, plugin FROM mysql.user;

  If you see 'root'@'localhost' using auth_socket , that's why your password isn't working.

Fix it by updating the authentication method:

 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';
FLUSH PRIVILEGES;

3. Running MySQL Without Proper Permissions

Sometimes, you might try to access MySQL from a regular terminal session without the right permissions, or you might be connecting via a GUI tool that assumes a different host or user.

Common fixes:

• Make sure you're connecting to localhost and not 127.0.0.1 unless needed.
• Use sudo if necessary when starting the client:

   sudo mysql -u root

• If you're using a tool like phpMyAdmin or MySQL Workbench, double-check connection settings — including username, password, and host.

4. Need to Reset Root Password via Safe Mode

If all else fails and you're locked out completely, resetting the password through safe mode is your best bet.

Steps:

• Stop MySQL:

   sudo systemctl stop mysql

• Start MySQL in safe mode:

   sudo mysqld_safe --skip-grant-tables &

• Connect without a password:

   mysql -u root

• Then run:

   FLUSH PRIVILEGES;
  ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';

• Restart MySQL normally:

   sudo systemctl restart mysql

This bypasses normal authentication temporarily so you can regain access.

That's basically what causes the "access denied for user 'root'@'localhost'" error after a fresh install. Most of the time, it's just a missing or mismatched password or a changed authentication method — nothing too serious once you know where to look.

以上是為什麼我會(huì)得到'訪問(wèn)用戶'root'@''localhost'的訪問(wèn)權(quán)限”，' localhost”''的詳細(xì)內(nèi)容。更多資訊請(qǐng)關(guān)注PHP中文網(wǎng)其他相關(guān)文章！