Database Manager – WP Adminer

2025-08-06 WP免费插件库 5

The best database management tool for the best CMS.

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

I am not the author of Adminer. I am only the author who does the WordPress integration with Adminer.
Author of Adminer is Jakub Vrana and you can donate him from there.

Compatible also with WordPress Multisite installations

WP Adminer access positions

You can access the WP Adminer from the below 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.

作者：Pexle Chris

截图：

The WP Adminer opened from Admin Bar
The new dropdown admin_bar items

额外信息：

版本 4.1.3

最后更新：5 天前

活跃安装数量 10,000+

WordPress 版本 4.7.0 或更高版本

已测试的最高版本为 6.8.2

PHP 版本 7.0 或更高版本

语言

评分：5

各个星级评论数量：95%#22#4%#1#0%#0#0%#0#0%#0

问答：

Is it safe?

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

Who has access to 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.

WP Adminer is stuck in an endless loop, constantly refreshing the page without stopping. What is the issue?

This issue maybe is due to the caching engine that your browser OR server uses!
* You can try to whitelist the WP Adminer URL, OR
* You can change the WP Adminer URL to a URL that is already whitelisted. For example:
define( ‘PEXLECHRIS_ADMINER_SLUG’, ‘wp-admin/adminer’);

How to add my own JS and/or CSS in adminer head?

You need to use action pexlechris_adminer_head as follows:

How can I change the WP Adminer children items at the admin bar?

You can do this using WP filter: pexlechris_adminer_adminbar_dropdown_items.
Filter’s PHPDoc:

How can I add other Adminer plugins or Adminer extensions?

In Adminer’s website there is documentation about Adminer plugins and Adminer extensions.
In order to define function adminer_object() before this plugin define it, you need to define it inside the hook pexlechris_adminer_before_adminer_loads.
More in the phpDoc below:

Can I limit access to some table/DB ?

The answer in this question is complicated.
The best solution is to create a Database User with the appropriate privileges.
Maybe you can do it also with WordPress actions.
Read more in this support ticket.

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.

插件官方网址：https://cn.wordpress.org/plugins/pexlechris-adminer/

下载数量：10000

缩略图网址：https://ps.w.org/pexlechris-adminer/assets/icon-256x256.png?rev=2685107

Database Manager – WP Adminer

WP Adminer access positions

Explore my other plugins

猜你喜欢

MC4WP: Mailchimp for WordPress

TruVisibility Plagiarism Checker

EHx Members

Contact Form Builder by RioForms – Drag & Drop WordPress Form Plugin

Edit Recent Edited Posts

Clean Post Content

评论0

社交账号快速登录

社交账号快速登录