Shulou(Shulou.com)05/31 Report--

This article mainly explains the "mysql root password forgot how to do", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "mysql root password forgot how to do" it!

[root@mgtjwzqas01v etc] # vi my.cnf

Skip-grant-tables

[root@mgtjwzqas01v etc] # systemctl stop mysqld

[root@mgtjwzqas01v etc] # systemctl start mysqld

[root@mgtjwzqas01v etc] # mysql-uroot

Use mysql

-pay attention to the password strength must match

Update mysql.user set authentication_string=password ('xxx') where user='root'

Flush privileges

[root@mgtjwzqas01v etc] # vi my.cnf

# skip-grant-tables

[root@mgtjwzqas01v etc] # systemctl stop mysqld

[root@mgtjwzqas01v etc] # systemctl start mysqld

[root@mgtjwzqas01v etc] # mysql-uroot-p

Thank you for reading, the above is the "mysql root password forgot how to do" the content, after the study of this article, I believe you forget how to do the mysql root password has a deeper understanding of this problem, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.