Database Management tool — Adminer

Description

The best database management tool for the best CMS.

This plugin uses the tool Adminer 4.8.1 in order to give database access to administrators directly from the Dashboard.
As simple as the previous sentence!

Compatible also with WordPress Multisite installations

WP Adminer access positions

You can access the WP Adminer from the above positions:
1. WP Adminer URL in the Admin Bar
2. WP Adminer Tools Page (Dashboard > Tools > WP Adminer)

Explore my other plugins

  • Library Viewer: With Library Viewer, you can display the containing files and the containing folders of a “specific folder” of your (FTP) server to your users in the front-end.
  • Gift Wrapping for WooCommerce: This plugin allows customers to select a gift wrapper for their orders, via a checkbox in the checkout page.

Screenshots

  • The WP Adminer opened from Admin Bar

Installation

  1. Download the plugin from Official WP Plugin Repository
  2. Upload Plugin from your WP Dashboard ( Plugins > Add New > Upload Plugin ) the pexlechris-adminer.zip file.
  3. Activate the plugin through the ‘Plugins’ menu in WordPress Dashboard

FAQ

Is it safe?

Yes, because only administrators have access to WP Adminer. If a guest try to access the WP Adminer URL, a 404 page will be shown up.

Who have access in WP Adminer?

 

  • In the case of single site WordPress installations, only Administrators have access in WP Adminer, because by default only administrator have the manage_options capability.
  • In the case of WordPress Multisite installations, only Super Admins have access in WP Adminer, because by default only Super Admins have the manage_network_options capability.

How to allow other capabilities or roles to have access to WP Adminer?

Just use the filter pexlechris_adminer_access_capabilities and return the array of desired capabilities that you want to have access to WP Adminer.
For roles, just use the corresponding capabilities, while checking against particular roles in place of a capability is supported in part, this practice is discouraged as it may produce unreliable results.

How can I access other databases in the same server and same database user?

By default, you haven’t access to any database other than the site’s database. In order to enable access, you need to add the following line code define('PEXLECHRIS_ADMINER_HAVE_ACCESS_ONLY_IN_WP_DB', false); in the wp-config.php file.

Why is Adminer better than phpMyAdmin?

Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and more security. See detailed comparison.
Adminer development priorities are: 1. Security, 2. User experience, 3. Performance, 4. Feature set, 5. Size.

Reviews

14 Սեպտեմբերի, 2022
Thank you for this Adminer plugin! It has been a very long time (when ARI Adminer was taken offline) and is so very necessary as a database tool without having to bother clients for their database credentials. Pieter
20 Ապրիլի, 2022
Hi Chris, I've been using the 2017 version of Adminer till today and decided to use Database Management tool – Adminer instead for php version compatibility. It works pretty well as much as its elder. Did appreciate the full view opening from the Admin bar menu. DMT-A deserves a 5 star rating. Thanks a lot, regards, Theophil
24 Մարտի, 2022
Finally found ) Works exellent, only one thing in wishlist: in long-time import, we have a "Gateway timeout" error in browser. Can it be fixed?
28 Փետրվարի, 2022
thanks for this plugin! easy to use and well structured! you can easily edit your DB or whatever 🙂
26 Փետրվարի, 2022
Very good plugin, and looks pretty safe as well. You can access all the databases of the server, not only of the current installation, so it can completely replace other tools. Great job!
Read all 6 reviews

Contributors & Developers

“Database Management tool — Adminer” is open source software. The following people have contributed to this plugin.

Contributors

“Database Management tool — Adminer” has been translated into 1 locale. Thank you to the translators for their contributions.

Translate “Database Management tool — Adminer” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

2.0.1

  • Adminer is an admin tool, so now is considered as admin interface. is_admin() function now return true, when Adminer is viewed

2.0.0

  • Tested up to 6.0.1
  • PLEASE UPDATE NOW! Vulnerability issue with password as plain text fixed.
  • SOS! All functions and actions have been renamed. Please have a look in the code to find the new names, if you have written your own customization code before
  • Logout button have been hidden.
  • Adminer has been removed from Tools Page because iframes are not allowed in admin pages
  • print_css_inside_wp_adminer_tools_page action has been removed
  • print_js_inside_wp_adminer_tools_page action has been removed
  • print_js_inside_wp_adminer action has been removed
  • print_css_inside_wp_adminer action has been removed
  • From this version and then, developers can make their Adminer’ customizations using the function adminer_object
    in the NEW pexlechris_adminer_before_adminer_loads action
    and to print code in head, developers can use the NEW action pexlechris_adminer_head
  • From this version and then, this plugin is also compatible with WordPress Multisite installations
  • From this version and then, you can change the slug of adminer using the constant PEXLECHRIS_ADMINER_SLUG (By default, adminer loads from www.site.com/wp-adminer )
  • From this version and then, you can log in even if the password is empty string (For some local setups)
  • From this version and then, by default you can only show wordpress database (to enable managing of other databases in same server see FAQ)

1.0.0

  • Initial Release.