MySQL Manager
by GameAP
50 downloads
v0.1.1
Description
MySQL/MariaDB databases for game servers and panel users: provisioning, connection info, a data browser with inline editing, a SQL console, and import/export — all from the GameAP panel.
Features
- Instances — install MariaDB/MySQL on a node, or connect an existing (local or remote) instance; connectivity/version/capability checks.
- Databases — create for a game server or a panel user, drop with confirmation, adopt databases created outside the panel.
- Accounts — managed MySQL users with grants, attachment to panel users and
game servers, one-shot password display, rotation. System accounts
(
root@*,mysql.sys,mariadb.sys, …) are protected. - Browser — tables, structure, paginated/sorted/filtered rows, inline cell editing, insert and delete by primary key (PK-less tables are read-only).
- SQL console — one statement per run, capped rows and timeout, per-account
execution (
run asis shown), local history. - Import/export — chunked dump upload → node-side assembly → async restore; dumps exported as downloadable parts or straight into the game server's directory for the panel file manager.
- Drift report — registry vs live comparison; read-only unless applied.
- Orphans — databases of deleted game servers are flagged, never dropped automatically.