Database Access with Adminer

Description

Adminer is a database administration tool that allows viewing and editing of databases tables, routines, triggers, etc. It also allows running SQL statements to import data, make bulk changes, or perform other complex operations. It is similar in function to phpMyAdmin. It is intended for use by developers and those who have had experience with databases.

This plugin provides a secure connection to your WordPress database, limited to that which is saved in your WordPress configuration, and access is granted only to logged-in accounts that possess the edit_plugins capability (normally admins). This ensures it can only used by those who already have enough privilege to pose a risk to the installation. Each and every request to Adminer will first be authenticated using your WordPress session. Some security plugins impose extra restrictions on admin sessions, so this plugin may not work if you have one installed.

Note that any other databases on the same host and protected by the same credentials will also be accessible in Adminer. This is how databases operate and not a limitation of Adminer nor this plugin. If other databases need different access restrictions, they should have separate credentials.

Screenshots

  • The settings screen
  • Link to adminer
  • The Adminer interface, in the pepa-linha-dark theme.

Installation

After installing the plugin, go to Settings > Adminer to configure the plugin and confirm the warning about the risk to your data. Go to Tools > Adminer to use it.

Reviews

August 17, 2022
Secure and themed, just what I need. Of course I keep this plugin disabled, and only activate when I need to debug something. As an extra protection =)
July 14, 2022
Tried a different Adminer plugin but I prefer this one. It runs full screen and lets you change the theme. Occasionally shows a "cannot read credentials" message in Adminer but refreshing the page works.
Read all 2 reviews

Contributors & Developers

“Database Access with Adminer” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

2.0.0

  • No discernable changes to the end user.
  • Adds random suffixes to temporary files, which should decrease PHP’s likelihood of including an obsolete file from cache.
  • Changed namespace to match approved plugin title, rather than original submission.