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 WP Advance DB cleaner, WP-optimize, WP DB-manager, to carry out few tasks like optimising database, taking backup of WordPress database. Though, at times it’s become necessary to login 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 give you access to phpmyAdmin, and you can easily access it by logging into your cPanel. For Dreamhost, there is an alternate way, which I have explained in this tutorial. But, anyhow 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 SQL Executioner to execute arbitrary SQL queries against your WordPress database from the Admin.
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 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 usage 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. Earlier, we had a similar plugin call WPPhpmyadmin, which was a security threat due to an outdated version of the plugin, and now Adminer is compatible up to WordPress 3.6, and is constantly updated. You can also use this plugin to take manual backup or database optimization of your WordPress blog.
Over all, 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 couple of articles that you can refer to:
If you know of any other similar plugins, do let me know via comment.