mysql密码忘记,怎么处理 (版本5.7以下)

优质老薛主机推荐:15%终身付款折扣:xwseo15 25%首次付款折扣 : xwseo115 点击下图进入购买

1.不验证密码登陆

[root@localhost ~]# mysqld_safe --skip-grant-tables --user=mysql &

2.在执行mysql 登陆(无需密码)

[root@localhost ~]# mysql   
Welcome to the MySQL monitor.  Commands end with ; or \g.  
Your MySQL connection id is 2004773  
Server version: 5.6.24 MySQL Community Server (GPL)  
  
Copyright (c) 2000, 2015, 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>

3.修改新密码(这张图片是在windows环境下)

mysql密码忘记,怎么处理 (版本5.7以下)

mysql> update mysql.user set password=password("laonm123") where user='root' and host='localhost';

4.刷新权限

mysql> flush privileges;  
Query OK, 0 rows affected (0.00 sec)  
  
mysql>

5.退出, 关闭mysql(这步相当重要)

[root@localhost ~]# mysqladmin -uroot -plaonm123 shutdown
140023 03:03:34 mysqld_safe mysqld from pid file /usr/........

6.启动mysql

[root@localhost ~]# /etc/init.d/mysqld start

7.正常登陆(使用新密码)

[root@localhost ~]# mysql -uroot -p  
Enter password:   
Welcome to the MySQL monitor.  Commands end with ; or \g.  
Your MySQL connection id is 2004814  
Server version: 5.6.24 MySQL Community Server (GPL)  
  
Copyright (c) 2000, 2015, 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>
赞 (0)
分享到:更多 ()

评论 0

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址