A reckless behavior: Unable to manipulate the database after modifying the MySQL root password in phpMyAdmin

First, the Hand of cheap behavior (????)

In a development of the PHP environment through the XAMPP mode, need to operate the database through phpMyAdmin access to MySQL, in a database operation when the memory is not set password, so directly in the user table in the MySQL database set the root user's password to " 123456 ", turn off the page, restart MySQL, access MySQL again via phpMyAdmin, and guess what happened

After entering MySQL, MySQL database disappears, I do not have the table permission, execute the use MySQL command error (Access denied for user "@ ' localhost ' to database ' MySQL '), as shown in

Second, try

Encounter problems of course is to solve the problem, can not use the database bar, so in the online toss, some solutions on the internet did not solve my problem, then how to do???

All kinds of ways have been tried, the problem is still there, no increase!

Give??? Unwilling to heart!!!

I do not know is not phpmyadmin problem, so I will all the changes to restore, swap with Mysql-front "root username, empty password" form login, the problem remains, disappointment!

Third, hope

Then I suddenly think that since the "root user name, empty password" way is access to MySQL, then I can not through the XAMPP Command window to enter, try a bit, success!

Then use the SQL statement to modify the password, success!

At this point, the problem solved, again using phpMyAdmin access to MySQL, how can not get into???

Naught???

A flash of light, it may be necessary to modify the C:\xampp\phpMyAdmin\config.inc.php file, so as follows to add the new settings password, re-visit, Success!

Now look at the user table in the MySQL database, as shown below:

Summary:

When you are unfamiliar with these tools, do not have a cheap hand (????)

If necessary, you can take a brief look at the information

A reckless behavior: Unable to manipulate the database after modifying the MySQL root password in phpMyAdmin