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

This article introduces the relevant knowledge of "how to find the mysql login password under the CentOS system". In the operation of the actual case, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

In using the CentOS system, you may set passwords for a lot of things to protect your computer's security, etc., then, if you accidentally forget the password, it may bring a lot of inconvenience to your work. Next we will help you solve a problem about the mysql login password in the CentOS system.

What if the login password of mysql is forgotten in the CentOS system? Use safe mode.

First, you need to stop mysql on the CentOS system:

# service mysqld stop

# / usr/bin/mysqld_safe-- skip-grant-tables &

The following continue to be typed in the CentOS system:

Msql > mysql-u root-p

The following password can be typed directly into enter.

The following is to reset the password on the CentOS system:

Mysql > update mysql.user set password=password ("New password") where user= "root"

Refresh permissions

Mysql > flush privileges

Quit

Mysql > exit

Start mysql and continue the previous login action.

# / rc.d/init.d/mysqld start

# mysql-u root-p

In this way, we should not be afraid of losing the login password of mysql on the CentOS system.

This is the end of the content of "how to find the mysql login password under the CentOS system". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.