---

How to Reset MySQL Root Password in XAMPP and Fix Table Corruption Issues

If you’re using XAMPP and encounter access issues with your MySQL database, it may be necessary to reset your root password or address table corruption. This guide will walk you through both processes step by step.

Step 1: Stop the MySQL Service

1. Open XAMPP Control Panel:

• Locate the XAMPP Control Panel and open it.

1. Stop MySQL:

• Click on the “Stop” button next to MySQL.

Step 2: Open Command Prompt as Administrator

1. Search for Command Prompt:

• Type “cmd” in the Windows search bar.
• Right-click on “Command Prompt” and select “Run as administrator”.

Step 3: Navigate to the MySQL Bin Directory

In the command prompt, navigate to the MySQL bin directory:

cd C:\xampp\mysql\bin

Step 4: Start MySQL in Safe Mode

To allow access without password checks, run the following command:

mysqld --skip-grant-tables

Keep this command prompt open. You should see messages indicating that MySQL is running.

Step 5: Open Another Command Prompt

1. Open a New Command Prompt (do not close the one running mysqld).

Step 6: Log into MySQL

In the new command prompt, type:

mysql -u root

You should now have access to the MySQL prompt without a password.

Step 7: Update the Root Password

Once logged in, update the root password using the following commands:

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

Replace new_password with your desired password.

Step 8: Exit MySQL

To log out of MySQL, type:

exit;

Step 9: Stop the Safe Mode MySQL

Go back to the command prompt running mysqld and stop it (you can close that command prompt).

Step 10: Start MySQL Normally

Return to the XAMPP Control Panel and start the MySQL service again.

Step 11: Test the New Password

Open a new command prompt and test the new password:

mysql -u root -p

Enter the new password you set.

Step 12: Fixing Table Corruption Issues

If you encounter an error like Got error 176 "Read page with wrong checksum" from storage engine Aria, follow these steps to address table corruption:

12.1. Check for Table Corruption

First, check for corruption by running:

CHECK TABLE `table_name`;  -- Replace `table_name` with your table

12.2. Repair Corrupted Tables

If corruption is detected, repair the table:

REPAIR TABLE `table_name`;

12.3. Use myisamchk (for MyISAM Tables)

If your tables use the MyISAM engine, you can use myisamchk:

1. Stop MySQL:

• Use the XAMPP Control Panel to stop the MySQL service.

1. Open Command Prompt:

• Navigate to the MySQL data directory:

   cd C:\xampp\mysql\data

3. Run myisamchk:

   myisamchk -r *.MYI

4. Restart MySQL:

• Start the MySQL service from the XAMPP Control Panel.

Conclusion

By following these steps, you can reset your MySQL root password and address any corruption issues in your database tables. Regular backups are essential to prevent data loss. If you continue to face issues, consider reinstalling XAMPP or further investigating the specific errors.

---