Database Access with Adminer

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.

It comes with all the themes published in Adminer’s Git repository, so you can select a style that suits you.

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

3.0.1

• Fix issue with style selection. Re-save your existing settings to ensure correct loading if using a dark theme.
• Clearer error when plugin deactivated.

3.0.0

• Major Adminer upgrade.
• All current styles selectable.
• Option for less restrictive permissions on ephemeral files, for environments where Adminer won’t because the file group differs from file owner (typically when PHP and the web server run under different accounts).

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.