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

How does the virtual host change the database password? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

When we forget the mysql virtual host database password, we will not be able to enter the database normally, and we will not be able to change the password, so how to change the password? here are some common ways to change the database password.

1. Open the folder where mysql.exe and mysqld.exe are located and copy the path address. Open the cmd command prompt and enter the folder where mysql.exe is located.

two。 Enter the command mysqld-- skip-grant-tables enter, and user authentication for mysql is skipped. After entering this command, the command line cannot be operated, and a new command line can be opened at this time. Note: end the mysqld.exe process in the task manager before entering this command to make sure that the mysql server side has finished running.

3. Then enter mysql directly, and you can log in to the database without any login parameters. Enter show databases; to see all database instructions for successful login.

4. The mysql library is where the user name is saved. Enter use mysql; to select the mysql database. Show tables looks at all the tables and finds a user table that stores account information such as user name, password, permissions, and so on.

5. Enter the command to view the account information. Change the root password and enter the command update user set password = password (123456) where user='root' and host='localhost'.

6. If you check the account information again, you can see that the password has been changed. Exit the command line, restart the mysql database, and try to log in with the new password.

This is the answer to the question about how the virtual host modifies the database password. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

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.