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

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

Themed!

opicron 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 =)

Does the job

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

Contributors & Developers

Changelog

2.1.0

• Preserve Adminer URL if session times out.
• Improved stability of login status verification.
• Attempt to copy selected style file if symbolic link creation fails.
• Prevent a useless PHP warning generated by Adminer.

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.