Opterius uses MariaDB as its database engine. All database operations — creating databases, managing users, granting privileges, and toggling remote access — are handled by the Opterius Agent via its /databases/* endpoints. You do not need direct mysql shell access from the panel to perform routine tasks.
Naming Convention
Every database and database user is prefixed with the account username to prevent collisions between accounts on the same server.
- Database name:
username_dbname - Database user:
username_dbuser
When you create a database named shop under account alice, it becomes alice_shop in MariaDB. The panel displays both the short name you chose and the full prefixed name.
MySQL User Per Account
Each hosting account gets a primary MySQL user created at account setup time. Additional users can be created and scoped to specific databases. No account can access another account's databases — user privileges are granted only to that account's prefixed databases.
phpMyAdmin
A shared phpMyAdmin instance is available at:
https://YOUR_SERVER:8081
Log in with a database username and password — not your panel password. You will only see the databases that your MySQL user has been granted access to. See phpMyAdmin for details.
Remote Access
By default, all database connections are restricted to localhost. Remote access can be enabled per database user from the panel. See Remote MySQL Access.
Agent-Managed DDL
The Opterius Agent handles all DDL operations:
| Action | Agent Endpoint |
|---|---|
| Create database | POST /databases/create |
| Delete database | POST /databases/delete |
| Create user | POST /databases/user-create |
| Delete user | POST /databases/user-delete |
| Change password | POST /databases/user-password |
| Grant privileges | POST /databases/grant |
| Toggle remote access | POST /databases/remote-access |
You will not need to run raw SQL DDL statements for any of these operations through the panel.