How to Reset the MySQL ROOT Password in a Windows Environment while Ignoring a TIMESTAMP Warning?

Resetting the MySQL ROOT password in a Windows Environment

When attempting to reset your MySQL root password using the provided instructions, you may encounter a warning message regarding implicit DEFAULT value for TIMESTAMP. This message is primarily a notification and does not necessarily require any specific action.

To successfully reset the password, it's recommended to follow these steps:

1. Shut down the MySQL service.
2. Navigate to the "my.ini" file located in "C:ProgramDataMySQLMySQL Server 5.6." Ensure the "ProgramData" folder is not hidden.
3. Add the line "skip-grant-tables" below the "[mysqld]" section and save the file.
4. Start the MySQL service once again.
5. Open a command prompt with administrator privileges.
6. Run the following command: "mysql -u root" to enter the MySQL terminal.
7. Issue the query "update mysql.user set password=PASSWORD('NEW PASSWORD') where user='root'" to update the password. For newer versions, use "authentication_string" instead of "password."
8. Type "FLUSH PRIVILEGES" to apply the changes.
9. Exit the MySQL terminal using "q."
10. Shut down the MySQL service.
11. Remove the "skip-grant-tables" line from the "my.ini" file.
12. Restart the MySQL service.

Once completed, you should be able to use the new password to log into your MySQL server. The warning message encountered during the process can be disregarded as it does not impact the password reset procedure.

The above is the detailed content of How to Reset the MySQL ROOT Password in a Windows Environment while Ignoring a TIMESTAMP Warning?. For more information, please follow other related articles on the PHP Chinese website!