MySQL management is one of the essential parts of WordPress management.
Most of us (WordPress bloggers), don’t use it on the day to day basis, or should I say we take help of plugins like:
to carry out few tasks like optimizing database, taking backup of WordPress database.
Though, at times it’s become necessary to log in to your phpMyAdmin to do few stuff. For example, when you want to delete a custom field from your WordPress database.
Most of the shared hosting gives you the access to PHPMyAdmin, and you can easily access it by logging into your cPanel.
This increases the time to access your MySQL database and carry out various MySQL management task.
Today, I will be talking about one useful plugin call which will help you to access phpMyAdmin from WordPress dashboard.
How to use Adminer to access your WordPress blog database?
Update: This plugin is no more available at plugin repo. You can use ARI Adminder WordPress plugin.
Adminer gives you the ability to access phpMyAdmin inside your WordPress dashboard, and you can easily manage your MySQL database inside WP dashboard. This is a free WordPress plugin, and once installed (
Download link), you can access Adminer settings under the tools section.
Go to Tools > Adminer and it will open a window with your database information.
One good use of this plugin is to retrieve your WordPress database password.
Simply go to Tools > Adminer and it will show you your database password. Click on Start Adminer inside, and you will be inside your hosting PHPMyadmin.
This plugin is very useful for anyone, who have to work inside PHPMyAdmin.
Though, just to be on the safer side, I suggest activating this plugin only when you need. You can also use this plugin to take manual backup or database optimization of your WordPress blog.
Overall, this is one quick solution to access PHPMyadmin from your WordPress dashboard. In case if you are wondering what all you can do with PHPMyAdmin, here are a couple of articles that you can refer to:
If you know of any other similar plugins, do let me know via comment.