Mysql 之忘记密码篇

最近在测试环境瞎玩mysql, 把mysql登录密码给弄的不记得了。

在网上找了下修改密码方法，记录如下：

方法如下：

    1，修改MySQL的登录设置

vim /etc/my.cnf   //打开配置文件，在[mysqld]下添加如下语句，保存退出
[mysqld]
skip-grant-tables

    2，重新启动mysqld 

[root@bogon ~]# sudo service mysql restart  //重启
Shutting down MySQL..... SUCCESS! 
Starting MySQL....................... SUCCESS

    3，登录并修改MySQL的root密码

[root@bogon mysql]# mysql -uroot -p   // 现在等数据库不需要密码了，直接回车就可以进去
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.35 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> USE mysql ; 
mysql> UPDATE user SET Password = password ( '123456' ) WHERE User = 'root' ;
Query OK, 3 rows affected (0.12 sec)
Rows matched: 4  Changed: 3  Warnings: 0
mysql> flush privileges ; 
Query OK, 0 rows affected (0.01 sec)
mysql> quit
Bye

    4，将MySQL中配置文件修改的内容修改回来，（将skip-grant-tables删除 ）

    5，重新启动mysqld ，然后可以用新密码登录了。