What should I do if I forget mysql password?

When you use a MySQL database, you need to set a username and password for login and management. However, sometimes we may forget the password for the MySQL database, or no longer have access to the database for some reason.

If you encounter such a problem, don't worry. In this article, I will describe several solutions to help you restore access and reset the password for your MySQL database.

1. Use the root user to log in

If you are using the root user to log in to the mysql server, you can use the root user's permissions to easily reset the MySQL database password. Enter the following command in the terminal window to log in as root:

sudo mysql -u root

You will be prompted to enter a password, but the password can be empty, just press Enter.

Next, you can change the root user's password with the following command:

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

In this command, replace "new_password" with the new password you want to set. Once done, refresh the permissions using the following command:

FLUSH PRIVILEGES;

2. Modify MySQL Configuration File

If you don't have access to the root user, or you don't want to log in as that user MySQL server, you can modify the MySQL configuration file to enable specific options that allow you to skip the password and use MySQL.

On Ubuntu, the MySQL configuration file is located at /etc/mysql/mysql.conf.d/mysqld.cnf. Open this file and add the following content at the bottom of the file:

[mysqld]
skip-grant-tables

Then, restart the MySQL server to use the following command:

sudo systemctl restart mysql

Now, you can connect to the MySQL server using the following command:

mysql -u root

No password is required at this time. When you successfully connect, use the following command to change the password:

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

Here, replace "new_password" with the new password you want to set. Once completed, refresh the permissions using the following command:

FLUSH PRIVILEGES;

Finally, remove the skip-grant-tables option you previously added to the mysqld.cnf file and restart the MySQL server.

3. Use the methods in the official MySQL documentation

The official MySQL documentation provides some methods to restore access to the MySQL account and change the password. This includes using the MySQL security utility or starting the MySQL server in MySQL safe mode.

These methods require a high technical level and in-depth knowledge of the MySQL system, so if you are a MySQL beginner, this may not be the best option.

Summary

If you forget your MySQL database password, don’t panic. Try logging in as root and changing the password, or modify the MySQL configuration file to allow you to skip the password. If none of these methods work, you can use other methods provided in the official MySQL documentation to restore access.

No matter which method you choose, it is very important to reset your MySQL database password and maintain the security of your database.

The above is the detailed content of What should I do if I forget mysql password?. For more information, please follow other related articles on the PHP Chinese website!