Linux server-mysql forgot the root password

Forgot root password

If you accidentally forget your root password, mysql will no longer be able to log in, and you will have to reset your root password. By following the steps below, we can reset the root password.

1. Exit MySQL

[root@localhost src]# service mysqld stop

Stop mysqld: [OK]

[root@localhost src]#

2. Enter sql safe mode with the command " /usr/bin/mysqld_safe --skip-grant-table & "

[root@localhost src]# /usr/bin/mysqld_safe --skip-grant-table &

[1] 6332

[root@localhost src]# 180814 10:10:00 mysqld_safe Logging to '/var/log/mysqld.log'.

180814 10:10:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

3. Log in without password, command "mysql -u root"

[root@localhost src]# mysql -u root

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

Your MySQL connection id is 1

Server version: 5.1.71 Source distribution

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

4. Use mysql with the command "use mysql;"

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>

5. Reset the root password, command "update user set password=password (" password ") where user='root'"

mysql> update user set password=password('123456') where user='root';

Query OK, 3 rows affected (0.00 sec)

Rows matched: 3 Changed: 3 Warnings: 0

mysql>

6. Refresh

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

7. Log out and log in again

[root@localhost src]# mysql -u root -p

Enter password: //Enter new password here

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

Your MySQL connection id is 2

Sever version: 5.1.71 Source distribution

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

Made a Linux learning platform, currently out of a prototype, you can refer to the use

Link: https://pan.baidu.com/s/1GOLVU2CbpBNGtunztVpaCQ Password:n7bk