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

The following mainly brings you to use oneinstack installation mysql forget password processing method, hope to use oneinstack installation mysql forget password processing method can bring you practical use, this is also the main purpose of my editing this article. Okay, no more nonsense, let's go straight to the following.

Forgot root password Change method:

1) Add skip-grant-tables to [mysqld] in my.cnf, restart mysql

service mysql restart

/bin/systemctl restart mysql.service

2) Log in with mysql command, note that there are only these 5 characters, nothing else.

3) Change to MySQL This database uses MySQL

update user set password=password ('new_password') where user='root';

mysql version 5.7:

update mysql.user set authentication_string=password('test123') where user='root' and Host = 'localhost';

5) After success, use flush privileges; refresh it. t forget to put a "#" before skip-grant-tables in my.cnf,

Restart MySQL again.

For the above on the use of oneinstack installation mysql forget password processing method, we do not feel very helpful. If you need to know more, please continue to pay attention to our industry information, I believe you will like these contents.

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.