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

Because I haven't used the database on my notebook for a long time, I forgot my password, so I can't get into the database.

Found a method, modified successfully, record it. [recommended tutorial: MySQL tutorial]

First find the bin directory under the mysql installation directory and copy the bin directory

Open the console as an administrator. I'm win10. When I came in, it was like this.

And then this place can't be directly changed to the bin directory of mysql, which is a little different from win7. It will report an error, like this.

I was also very confused at that time, and then I found that I needed to type a cmd before I could switch to the bin directory.

There are two ways to stop the mysql service first

Use the command net stop mysql

The second method: win+R, enter services.msc, enter enter, then find mysql, and right-click to stop.

Next, just go to the bin directory, enter the command mysqld-skip-grant-tables, this is to skip password verification, and then you need to reopen a command window, which just can't be used (knock on the blackboard, highlight, take notebook and write it down, to re-open the administrator command window) enter the bin directory, type mysql, and then you can enter the database.

You can see the contents of the database with the command show databases;, where the mysql library is where the user name is saved. Enter use mysql; to select the mysql database

7. Show tables looks at all the tables and finds a user table, which stores account information such as user name, password, permissions, and so on.

Enter select user,host,password from user; to view the account information.

Change the root password and enter update user set password=password ('root') where user='root' and host='localhost'; to change the password to root. Prompt Query ok to modify it.

10. After looking at the account information, select user,host,password from user; can see that the password has been changed.

Exit the command line, restart the mysql database, enter mysql-uroot-p in the bin directory, you will be prompted to enter the password, then log in with the new password and you will be able to log in.

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.