In linux, how does one forget the root password of mysql? mysqlroot

In linux, how does one forget the root password of mysql? mysqlroot

Five steps to easily solve the problem of forgetting the mysql root Password, I hope to help you.

1. Modify MySQL Logon Settings:

# Vi/etc/my. cnf

In the [mysqld] section, add skip-grant-tables

For example:

[Mysqld] datadir =/var/lib/mysql socket =/var/lib/mysql. sock skip-grant-tables

2. Restart mysql

# Service mysql start

3. log on to and modify the MySQL root Password

# Mysql> USE mysql; mysql> UPDATE user SET Password = password ('new-password') WHERE User = 'root'; mysql> flush privileges; mysql> quit

4. Modify the MySQL Logon Settings

# Vi/etc/my. cnf

Delete the skip-grant-tables added to the [mysqld] section.

5. Restart mysqld

# Service mysql start

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.