Adminer : Access phpMyAdmin Inside WordPress Dashboard

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

Article By
Harsh Agrawal is a blog scientist and a passionate blogger. He is blogging since 2008 & writes about Blogging, SEO, Make money online & tech. His blog, ShoutMeLoud receives 1 million Pageviews/month and have over 700K subscribers.


COMMENTs ( 6 )

  1. says

    This plugin is very handy. :)
    There are times that try a similar solution within the dashboard, moreover it is updated and very well rated by its more than 40k users.
    Very grateful for sharing this finding.

  2. sanjeev says

    can anyone tell me where i can get some info (ideally a tutorial) on how to use Adminer, i am new to this and seriously need help.

  3. Steve says

    Brilliant! I’ve been trying to create a new database on an Amazon cloud server for hours. Thank you.