What if the phpmyadmin and mysql consoles display different lists of databases

Here's what to do about the difference in the list of databases displayed on the phpmyadmin and mysql consoles. The secret of the text is close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article after reading the phpmyadmin and mysql console showing a different list of databases.

After installing bugfree using xampp, log in to phpmyadmin and find that the bugfree database is not displayed. After querying using the mysql console, it is found that the bugfree database does exist, as shown in the following figure:

Analyze the problem: this is because there are other mysql services on. Open the task manager and turn off other mysql services, as shown below:

Modified result: after shutting down other unrelated mysql services, refreshing the phpmyadmin page will display normally, as shown below:

Conclusion: when you encounter problems, we should learn to constantly troubleshoot problems and try solutions, constantly sum up, and strive to improve their own level of practice.

For the above phpmyadmin and mysql console display database list is not the same how to do the relevant content, is there anything you do not understand? Or if you want to know more about it, you can continue to follow our industry information section.