Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Explain how to reset the MySQL root (Root) password under Redhat Linux (CentOS)

2025-01-20 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

1. First enter "service mysqld status" to view the current mysql service status, and the following figure shows that the mysqld service is running.

two。 Enter the "killall-TERM mysqld" command to stop all mysqld processes.

3. Enter the "service mysqld stop" command to stop the mysqld service.

4. Enter MySQL security mode without a password by entering the "mysqld_safe-- skip-grant-tables &" command.

5. Enter "mysql-u root" and press enter.

6. Enter "use mysql;" to mount the database.

Note: do not forget to enter the semicolon (;) at the end.

7. Enter "update user set password=password (" Redhat ") where user='root' to change the Root password to New9ssw0rd.

8. Enter "flush privileges;" update permissions.

9. Enter "quit" and press enter to exit.

Note: there is no need to enter semicolons here.

10. Enter "service mysqld restart" to restart the mysqld service.

11. Enter "mysql-u root-p" and press enter to prompt for the password.

twelve。 Enter the new password Redhat and press enter to indicate that you have logged in successfully.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report