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.