Forgot mysql password in linux

Forgetting the MySQL password under Linux is a common problem. This problem can be very tricky if you don't have a backup or if you haven't set a root password before. The following are some solutions:

1. Use mysql_safe mode to reset password

This method is used when restarting the MySQL service under Linux parameter settings. First, you need to stop the running MySQL service. Enter the following command:

service mysqld stop

Then, start MySQL in safe mode, which will not require a password to log in. Enter the following command:

mysqld_safe --skip-grant-tables &

Note that the & symbol is required, this will run mysqld_safe in the background.

Enter the following command to reset the root user's password:

mysql -u root

Enter the following command to change the root password to a new password. Here, my new password is "P@ssw0rd" but you can change it to your own:

use mysql;
update user set password=PASSWORD("P@ssw0rd") where User='root';
flush privileges;
quit

Exit the MySQL service. Restart MySQL for the new password to take effect.

service mysqld restart

Now, you can log in to MySQL using the updated root password.

2. Use sudo dpkg-reconfigure mysql-server-5.x to reset the password

This method is suitable for users using Debian or Ubuntu Linux operating systems. First, you need to stop the running MySQL:

sudo /etc/init.d/mysql stop

Use the following command to reset the MySQL password:

sudo dpkg-reconfigure mysql-server-5.x

Note that the "x" in the above command should be replaced with the MySQL version in use.

This command will guide the user through the MySQL reconfiguration process. During this process, the user will be prompted to enter a new password.

Restart the MySQL service:

sudo /etc/init.d/mysql start

3. Use the mysqld --skip-grant-tables command to reset the password

This method is suitable for CentOS, Linux operating systems such as Fedora and RHEL. First, you need to stop the running MySQL service:

service mysqld stop

Use the mysqld_safe command to start the MySQL service, which will disable password verification:

mysqld_safe --skip-grant-tables &

After starting the MySQL service, you will be prompted to enter a new Password:

mysqladmin -u root password NEWPASSWORD

Enter the following command to restart the MySQL service:

service mysqld restart

Now, you can log in to MySQL using the new password.

Summary

Forgetting your MySQL password can cause a lot of problems, so you need to know how to reset your password. This article introduces three different methods: using mysql_safe mode to reset the password, using sudo dpkg-reconfigure mysql-server-5.x to reset the password, and using the mysqld --skip-grant-tables command to reset the password. Before using either method, be sure to back up your database to avoid accidental data loss.

The above is the detailed content of Forgot mysql password in linux. For more information, please follow other related articles on the PHP Chinese website!