centos6.5 mysql重置_centOS 6.5 mysql5.6忘记密码后重置密码

最新推荐文章于 2022-09-26 08:52:19 发布

weixin_39738774

最新推荐文章于 2022-09-26 08:52:19 发布

阅读量109

点赞数

文章标签： centos6.5 mysql重置

本文链接：https://blog.csdn.net/weixin_39738774/article/details/113653320

版权

当忘记CentOS 6.5上安装的MySQL 5.6的密码时，可以通过以下步骤重置：1) 停止MySQL服务；2) 使用mysqld_safe启动时跳过权限表；3) 新开窗口并进入MySQL，更新root用户的密码；4) 刷新权限；5) 终止后台进程；6) 测试新密码登录。

摘要由CSDN通过智能技术生成

1、停止mysql服务 service mysqld stop

[root@wuwu1 ~]# service mysqld stopStopping mysqld: [ OK ]

2、 [root@wuwu1 ~]# mysqld_safe --skip-grant-tables

170403 08:02:17 mysqld_safe Logging to '/var/log/mysqld.log'.

170403 08:02:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

3、新开窗口进入mysql

4、mysql> use mysql

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> update user set password=password("12345") where user="root";

Query OK, 3 rows affected (0.00 sec)

Rows matched: 3 Changed: 3 Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

ByeReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> update user set password=password("12345") where user="root";Query OK, 3 rows affected (0.00 sec)Rows matched: 3 Changed: 3 Warnings: 0mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> exitBye

flush privileges;刷新权限

5终止第一个窗口的后台进程

ctrl + z

6测试密码进入

mysql -uroot -p12345Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.1.73 Source distributionCopyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>