ShoutMeLoud – Shouters Who Inspire

Superlinks
≡ Menu
≡ Menu

Adminer : Access phpMyAdmin Inside WordPress Dashboard

TA
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.

  • Author Bio

  • Latest Post

Article by Harsh Agrawal

Harsh has written 1071 articles.

If you like This post, you can follow ShoutMeLoud on Twitter. Subscribe to ShoutMeLoud feed via RSS or EMAIL to receive instant updates.


{ 3 comments… add one }

  • Mukul Bansal

    Simple and a easy way of taking Database Backups…. You even dont need to login into Cpanel

    Reply
  • Ugee

    Wow, I never really knew that this was possible. Thanks for this Harsh. I’ll start using it

    Reply
  • Kinjalk Tiwari

    Wow ! a great tool . It is very useful for Wordpress Bloggers specially for who don’t have phpMyAdmin .

    Reply

Leave a Comment