Adminer ​
Adminer is a database management tool integrated into AdminBolt. It provides a web-based interface for managing databases directly from the admin panel.
Overview ​
URL: /admin/settings/adminer
Navigate to Settings > Databases > Adminer.
The Adminer page serves as a gateway to the Adminer database management interface. It presents four login options, each connecting to a different database on your server.
Login Options ​
The page displays the question "Where do you want to login?" followed by four cards:
| Option | Description |
|---|---|
| Login to Panel Database | Connects to the AdminBolt panel's own database. Use this to inspect or manage the panel's internal data. |
| Login to MariaDB | Connects to the main MariaDB server. Use this to manage hosting account databases and other user databases. |
| Login to Mailserver Database | Connects to the mail server database read-only and lists its tables. Use this to inspect email-related data (accounts, domains, etc.). Read-only since panel 1.9.0. |
| Login to PowerDNS Database | Connects to the PowerDNS database read-only and lists its tables. Use this to inspect DNS zone data and records. Read-only since panel 1.9.0. |
Clicking any of the cards opens the Adminer interface in a new tab, automatically authenticated with the appropriate database credentials.
Who can open Adminer ​
Since panel 1.9.1, Adminer opens only for a signed-in user:
- Administrators signed in to the admin panel can open it, including the panel's own databases behind the Panel Database, Mailserver Database, and PowerDNS Database cards. Those databases open for administrators only.
- Customers signed in to the client panel, with an active hosting account, can open Adminer for their own PostgreSQL databases, from Open in Adminer on the client Databases page. A suspended account cannot open it.
Since panel 1.9.2, administrators open the server's databases in Adminer only. The Settings > Databases > PHPMyAdmin page, whose shortcuts opened the same databases in Adminer, is removed; phpMyAdmin stays available to customers in the client panel. See PHPMyAdmin.
Usage ​
Once logged in through one of the four options, you have access to Adminer's functionality, within the read-only limit of the mail server and PowerDNS cards, including:
- Browsing database tables and their structure
- Running SQL queries
- Viewing and editing table data
- Exporting and importing databases
- Managing database users and privileges
Note: Adminer replaces phpMyAdmin for administrators. If you have documentation or bookmarks that point to
/admin/settings/phpmyadminor/admin/phpmyadmin, change them to this page,/admin/settings/adminer. The page at those addresses was removed in panel 1.9.2.