MySQL and MariaDB Permissions helps review access and permission information for a monitored server.
Workflow
- Open Permissions.
- Review users, privileges, or permission rows shown by Mini DBA.
- If monitoring pages are missing data, verify the Mini DBA login has permission to read required system views.
- Apply security changes through your normal database access process.
How To Review MySQL And MariaDB Permissions
The Permissions page helps DBAs understand which users and privileges are visible to Mini DBA for a monitored MySQL or MariaDB server. It is useful during onboarding, security review, and troubleshooting when monitoring pages show less data than expected.
Start by confirming the Mini DBA monitoring account has the permissions described in Connect To MySQL And MariaDB. The connection guide includes example SQL for creating a monitoring user and granting the permissions required for server visibility. If a feature page is blank or incomplete, compare the missing data with the account privileges rather than assuming the server has no activity.
Use permission evidence carefully. Do not grant broad administrative access only to make a monitoring page more complete. Prefer the least privilege model that still supports the metrics your organization needs, and apply access changes through your normal database security process.
MySQL And MariaDB Permissions FAQ
Can Mini DBA monitor with a read-only user?
Yes for many metrics, but some features need access to system views, performance schema data, process information, or provider-specific metadata.
Why does one server show more permission data than another?
Version, flavor, cloud platform, configuration, and the grants assigned to the monitoring user can all change visibility.
Where is the example monitoring user SQL?
See Connect To MySQL And MariaDB for the connection workflow and grant examples.