Adminer : Access phpMyAdmin Inside WordPress Dashboard

IN Shoutmeloud, WordPress

MySQL management is one of the essential part of WordPress management. Most of us (WordPress bloggers), don’t use it on day to day basis, or should I say we take help of plugins like 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 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 Adminer, which will help you to access phpMyAdmin from WordPress dashboard.

How to use Adminer to access your WordPress blog database?

Adminer gives you 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 tools section.

Go to Tools > Adminer and it will open a window with your database information.

adminer wordpress plugin

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.

access WordPress phpmyadmin

This plugin is very useful for anyone, who have to work inside PhpMyadmin. Though, just to be on the safer side, I suggest to activate this plugin only when you need. Earlier, we had a similar plugin call WPPhpmyadmin, which was a security threat due to 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 daashboard. 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.

Subscribe on Youtube

Click to activate Offer & visit site Discount added automatically

Subscribe to SML Newsletter

Receive Blogging Tips & Strategies

Get WordPress Guide eBook for free in the 2nd newsletter

100% privacy. we will never spam you

  • Author Bio

  • Latest Post

Blog post by Harsh Agrawal

Harsh has written 1050 articles.

Follow ShoutMeLoud on Twitter. Subscribe to ShoutMeLoud feed via RSS or EMAIL to receive instant updates.

Send Us Inquiry


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>