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

Editor to share with you how to forget the root password in mysql, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Let mysql not load the permission table, command: mysqld-- skip-grant-tables

Command: mysqld-- skip-grant-tables (windows)

Mysqld_safe-skip-grant-tables user=mysql or / etc/init.d/mysql start-mysqld-skip-grant-tables (linux)

Example of Windows platform:

C:\ Users\ duansf > mysqld-- skip-grant-tables

Open another command window and enter the interactive interface of mysql

C:\ Users\ duansf > mysql-uroot-p

Enter password: *

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

Your MySQL connection id is 15

Server version: 5.5.13 MySQL Community Server (GPL)

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

Reset the root password with the update statement.

Mysql > show databases

+-+

| | Database |

+-+

| | information_schema |

| | mysql |

| | performance_schema |

| | test |

+-+

4 rows in set (0.07 sec)

Mysql > use mysql

Database changed

Mysql > update user set Password=password ('123456') where user='root'

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

Mysql > commit

Query OK, 0 rows affected (0.00 sec)

Mysql > flush privileges

Query OK, 0 rows affected (0.24 sec)

Log in again to verify whether the password change is successful.

C:\ Users\ duansf > mysql-u root-p123456

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

Your MySQL connection id is 16

Server version: 5.5.13 MySQL Community Server (GPL)

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

The above is all the contents of the article "I forgot what to do with root password in mysql". 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.