Adminer

A lightweight database management UI for advanced troubleshooting. Enable temporarily only.

Adminer is a powerful tool that exposes direct access to your databases. It should only be enabled temporarily when you need to inspect or repair data, and disabled immediately afterward. Do not leave Adminer running permanently.

What is Adminer?

Adminer is a lightweight web-based database management interface. It lets you browse database tables, run SQL queries, export data, and inspect records directly — without using the command line.

In ServicePlus, Adminer is available at db.yourdomain.com when enabled.

When to use Adminer

  • Inspecting a database table to debug an issue
  • Running a one-off SQL query that cannot be done through the service's UI
  • Exporting a specific table or dataset
  • Troubleshooting with the support team (share a screenshot of a record, not credentials)

When NOT to use Adminer

  • For routine data management — use Mautic's CRM interface instead
  • For viewing contacts — Mautic's contact browser is safer and tracks changes
  • As a permanent dashboard — it is an internal maintenance tool only

Enabling Adminer safely

  1. Enable: sp add adminer
  2. Access at https://db.yourdomain.com using the credentials from sp cred
  3. Do your work
  4. Disable immediately: sp remove adminer
Adminer does not store any data itself — removing it with sp remove adminerdoes not affect your databases. You can safely add and remove it as many times as needed.

Security best practices

  • Never share your Adminer URL publicly or post it in any channel
  • Change your Adminer access credentials periodically — run sp cred to check them
  • If you suspect unauthorized access, remove Adminer and contact support immediately