客户端mysql 密码忘了怎么办_mysql - 忘记root密码的解决方案

# 1、关闭mysqld服务

[root@localhost ~]# service mysqld stop

Shutting down MySQL.. SUCCESS!

# 2、使用mysqld_safe 启动mysql服务

[root@localhost ~]#/root/mysql/database/mysql/bin/mysqld_safe --skip-grant-tables --skip-networking

2021-01-11T19:56:27.731523Z mysqld_safe Logging to '/root/mysql/data/3306/localhost.localdomain.err'.2021-01-11T19:56:27.756552Z mysqld_safe Starting mysqld daemon with databases from /root/mysql/data/3306^Z

[1]+ Stopped /root/mysql/database/mysql/bin/mysqld_safe --skip-grant-tables --skip-networking

# 3、登陆mysql

[root@localhost ~]#mysql

Welcome to the MySQL monitor. Commands endwith ; or \g.

Your MySQL connection id is2Server version:5.7.28MySQL Community Server (GPL)

Copyright (c)2000, 2019, 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'forhelp. Type '\c' to clear the current input statement.

mysql>select user();+--------+

| user() |

+--------+

| root@ |

+--------+

1 row in set (0.00sec)

mysql>

# 4、更新root密码：

mysql> update mysql.user set authentication_string=PASSWORD('123') where `user`='root';

Query OK, 0 rows affected, 1 warning (0.01 sec)

Rows matched: 1 Changed: 0 Warnings: 1

# 5、退出mysql客户端

mysql> exit

Bye

# 6、重启mysql服务

[root@localhost ~]# service mysqld restart

Shutting down MySQL.. SUCCESS!

Starting MySQL. SUCCESS!

[root@localhost ~]#

# 7、重新登录mysql

[root@localhost ~]# mysql -uroot -p123

mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.7.28 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, 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>