User

phpMyAdmin

Accessing and using phpMyAdmin to manage your MariaDB databases through a browser.

Last updated 1775606400

phpMyAdmin is available at:

https://YOUR_SERVER:8081

Replace YOUR_SERVER with your server's hostname or IP address. The connection is HTTPS.

Logging In

Log in with your database username and password — not your Opterius panel login. You can find your database credentials in Hosting Mode → Databases → [database] → Credentials.

[!IMPORTANT] Your panel password does not work here. Each database user has its own MySQL credential set independently from your hosting account password.

Once logged in, you will see only the databases that your MySQL user has been granted access to. Other accounts' databases are not visible.

What You Can Do

Run queries — Use the SQL tab to run arbitrary SELECT, INSERT, UPDATE, or DELETE statements against your database.

Import SQL dumps — Go to the database → Import tab. Upload a .sql file to restore a database or load a schema. Useful for migrating a database from another host. See Database Backups for the export side.

Export SQL dumps — Go to the database → Export tab. Choose Quick or Custom export. The default SQL format produces a dump compatible with mysql CLI import.

Browse and edit rows — Click a table name to browse its rows. Click the edit icon on any row to modify it inline. Useful for one-off data fixes without writing SQL.

Manage table structure — Add columns, change types, add indexes, drop columns — all from the Structure tab.

Repair and optimize tables — Available under Operations tab per table. See Repair and Optimize for when to use these.

Notes

  • phpMyAdmin runs as a shared instance on the server. Multiple accounts use it simultaneously.
  • You only see what your MySQL user can access — there is no way to escalate to root or view other accounts.
  • Large imports (hundreds of MB) may time out through the browser. For large files, use mysql < dump.sql over SSH instead.