如果忘記了MySQL的root密碼，可以通過跳過授權(quán)表重置密碼。具體步驟如下：1. 停止MySQL服務(wù)器，根據(jù)系統(tǒng)使用不同的命令；2. 以--skip-grant-tables模式啟動MySQL，繞過密碼驗證；3. 登錄MySQL並根據(jù)版本執(zhí)行相應(yīng)的SQL命令更新root密碼；4. 正常重啟MySQL服務(wù)並使用新密碼登錄。整個過程不會丟失數(shù)據(jù)，但需嚴格按照步驟操作以避免錯誤。

If you've lost the root password for your MySQL server, don't panic — it's possible to reset it without losing your data. This process involves restarting MySQL in a special mode that bypasses the usual authentication. Here's how to do it.

Step 1: Stop the MySQL Server

Before you can reset the password, you need to stop the running MySQL instance. How you do this depends on your operating system.

• On Linux (systemd-based systems like Ubuntu or CentOS):

   sudo systemctl stop mysql

• On macOS (if installed via Homebrew):

  

   brew services stop mysql

Make sure no other processes are using MySQL before stopping it. If you run into issues, check if any background services are holding it open.

Step 2: Start MySQL in Skip-Grant Mode

Once the server is stopped, start it again with --skip-grant-tables . This allows access without requiring passwords.

On Linux:

 sudo mysqld_safe --skip-grant-tables &

On macOS: You may need to find the correct path to mysqld_safe first, usually /usr/local/opt/mysql/bin/mysqld_safe , then run:

 sudo /usr/local/opt/mysql/bin/mysqld_safe --skip-grant-tables &

This step is crucial because it lets you log in as root without knowing the current password.

Step 3: Log In and Reset the Password

Now connect to MySQL without a password:

 mysql -u root

Once inside the MySQL shell, update the root password. The exact command varies slightly depending on your MySQL version.

For MySQL 5.7 and earlier:

 UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root';
FLUSH PRIVILEGES;

For MySQL 8.0 and above:

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

Double-check the syntax here — a typo could leave you still locked out. Also, make sure you're using strong passwords this time around.

Step 4: Restart MySQL Normally

After changing the password, exit the MySQL shell:

 exit;

Then stop the MySQL instance again:

 sudo mysqladmin shutdown

And restart it normally:

• On Linux:

   sudo systemctl start mysql

• On macOS:

   brew services start mysql

Now try logging back in with your new password:

 mysql -u root -p

If it works, you're all set.

Basically, resetting the MySQL root password comes down to temporarily bypassing security checks, updating credentials directly in the database, and making sure everything restarts cleanly afterward. It's not complicated, but it does require careful steps and attention to detail.

以上是重置MySQL安裝的root密碼的詳細內(nèi)容。更多資訊請關(guān)注PHP中文網(wǎng)其他相關(guān)文章！