A reckless act: unable to operate the database after changing the MySQL root password in phpmyadmin

1. Handy behavior (✿◡‿◡)

　 During a development, I installed the PHP environment through 123456", close the page, restart MySQL, and access MySQL through phpmyadmin again, guess what happened

After entering MySQL, the mysql database disappeared, and I no longer have permission to create tables. When I execute the use mysql command, an error is reported (Access denied for user ''@'localhost' to database 'mysql'), as shown in the figure below

2. Try

When I encounter a problem, of course I have to solve it. I can’t use the database, so I searched a lot online. Some of the solutions online didn’t solve my problem. What should I do now? ? ?

I have tried various methods, but the problem is still there, neither increasing nor decreasing!

　Give up? ? ? Not willing to give in! ! !

I don’t know if it’s a problem with phpmyadmin, so I restored all the changes and switched to MySQL-Front to log in with “root username, empty password”. The problem still exists, I’m disappointed!

3. Hope

At this time, I suddenly thought that since MySQL can be accessed with "root username and empty password", can I enter through the command window of xampp? I tried it and it was successful!

So I then used SQL statements to change the password, and it was successful!

At this point, the problem is solved. Use phpmyadmin to access MySQL again. Why can’t I get in? ? ?

All your efforts have been wasted? ? ?

I had a flash of inspiration, maybe I need to modify the C:xamppphpMyAdminconfig.inc.php file, so I added the newly set password as follows, accessed again, and it was successful!

At this time, check the user table in the mysql database, the display is as follows:

Summary:

Don’t be shy if you are not familiar with these tools (✿◡‿◡)

If necessary, you can briefly look at the information first