Shulou(Shulou.com)05/31 Report--

This article mainly shows you "MySQL how to forget the root password", the content is easy to understand, clear, hope to help you solve the doubt, the following let the editor lead you to study and learn "MySQL how to forget the root password" this article.

1. Start MySQL

[root@localhost] # mysqld_safe-- skip-grant-tables &

2. Log in to MySQL

[root@localhost] # mysql-uroot-p

Enter password:

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

Your MySQL connection id is 1

Server version: 5.5.25a-log Source distribution

Copyright (c) 2000, 2011, 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 > show databases

+-+

| | Database |

+-+

| | information_schema |

| | allen |

| | mysql |

| | mytest |

| | performance_schema |

| | test |

+-+

6 rows in set (0.00 sec)

Mysql > use mysql

Database changed

Mysql > update user set password=PASSWORD ("123456") where user= "root";-- modify root password

Query OK, 4 rows affected (0.00 sec)

Rows matched: 4 Changed: 4 Warnings: 0

Mysql > flush privileges

Query OK, 0 rows affected (0.00 sec)

Mysql > quit

Bye

3. Log in with your password again

[root@localhost] # mysql-uroot-p123456

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

Your MySQL connection id is 2

Server version: 5.5.25a-log Source distribution

Copyright (c) 2000, 2011, 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 > show databases

+-+

| | Database |

+-+

| | information_schema |

| | allen |

| | mysql |

| | mytest |

| | performance_schema |

| | test |

+-+

6 rows in set (0.00 sec)

The above is all the contents of the article "how MySQL forgets root password". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.