要重置MySQL的root密碼，請按以下步驟操作：1. 停止MySQL服務(wù)器，使用sudo systemctl stop mysql或sudo systemctl stop mysqld；2. 以--skip-grant-tables模式啟動(dòng)MySQL，執(zhí)行sudo mysqld --skip-grant-tables &；3. 登錄MySQL並根據(jù)版本執(zhí)行相應(yīng)的SQL命令修改密碼，如FLUSH PRIVILEGES; ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_password'; 或UPDATE mysql.user SET authentication_string=PASSWORD('your_new_password') WHERE User='root'; FLUSH PRIVILEGES; 4. 正常重啟MySQL服務(wù)，先exit退出MySQL shell，再用sudo kill $(pgrep mysqld)停止臨時(shí)實(shí)例，最後用sudo systemctl start mysql重啟服務(wù)。

If you've lost the root password for your MySQL server, don't panic — it's possible to reset it without too much trouble. The key is to temporarily bypass the normal authentication system so you can set a new password. This process works best if you have access to the server machine and sudo privileges.

Step 1: Stop the MySQL Server

Before you can reset the password, you need to stop the running MySQL instance. If it's currently active, stopping it will allow you to restart it in a special mode.

• On most Linux systems, you can do this with:

   sudo systemctl stop mysql

  Or, if you're on a system using mysqld :

  

   sudo systemctl stop mysqld

Once the service is stopped, you're ready to move on to starting MySQL without loading the usual security restrictions.

Step 2: Start MySQL in Skip-Grant-Tables Mode

This step is crucial. Starting MySQL with the --skip-grant-tables option tells it not to load the permission system, which means you can log in without a password.

• You can start it manually like this:

   sudo mysqld --skip-grant-tables &

  (The & at the end sends the process to the background.)

Now you'll be able to connect to MySQL as root without any password.

Note: Make sure no other users or applications are trying to access the database during this time, as this leaves it vulnerable.

Step 3: Log in and Change the Password

With MySQL running in safe mode, connect to it:

 mysql -u root

You'll go straight into the MySQL prompt. From there, run the following SQL commands to update the root password.

• For MySQL 5.7 or 8.0:

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

• If you're using an older version:

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

Make sure to replace 'your_new_password' with something secure.

Step 4: Restart MySQL Normally

After setting the new password, shut down the temporary MySQL instance and restart the service normally.

• First, exit the MySQL shell:

   exit;

• Then stop the manual instance:

   sudo kill $(pgrep mysqld)

• And restart the service:

   sudo systemctl start mysql

Or again, use mysqld instead if that's what your system uses.

Try logging back in with your new password:

 mysql -u root -p

That's basically it. It's a straightforward process once you know the steps, but easy to forget if you haven't done it in a while. Just remember to always keep your credentials secure afterward — resetting passwords shouldn't be a regular thing.

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