Shulou(Shulou.com)06/01 Report--

The following mainly brings you linux system MySQL password forgot how to do, I hope these contents can bring you practical use, this is also my edit linux system MySQL password forgot how to do the main purpose of this article. All right, don't talk too much nonsense, let's just read the following.

Root permission is required for the following operations:

Enter the mysql configuration file / etc/my.cnf, add a line of skip-grant-tables under [mysqld], save and exit

Restart the MySQL service: service mysqld restart

Enter mysql:mysql-u root

Switch to MySQL database: use mysql

Reset the MySQL password: update user set password=password ('new-password') where user =' root'

Refresh permissions: flush privileges

Exit mysql, enter the configuration file / etc/my.cnf, delete or comment out skip-grant-tables, save and exit.

Restart the MySQL service: service mysqld restart, you can log in with a new password

For the above about the linux system MySQL password forgot how to do, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.