Working with your database

Every WordPress, Laravel, and Django site provisioned on CloudMagnus gets its own MySQL database. The Database tab on your site detail page shows the database name, user, and host you'll connect with. The password was issued at provisioning time and is the same one used by your framework's config (wp-config.php, .env, settings.py).

Where the password is stored

Your framework already has it. We don't show database passwords in the dashboard for v1 — they're written into your site's config file by the provisioning step and never recorded on our side. If you need the password for an external tool, look in:

  • WordPress: ~/htdocs/wp-config.php — the DB_PASSWORD constant.
  • Laravel: ~/htdocs/.env — the DB_PASSWORD line.
  • Django: ~/htdocs/<project>/settings.py — the DATABASES dict, or the .env the project sources.

SFTP in to read the file. The framework guides under Framework guides have per-stack details.

Connecting from the command line

v1 doesn't ship a phpMyAdmin replacement in the dashboard. The supported way to run SQL against your database is via SSH + the mysql client.

One-shot query

ssh [email protected]
mysql -u <db_user> -p <db_name>
# enter the password when prompted
mysql> SELECT COUNT(*) FROM wp_posts;

Run a SQL file

ssh [email protected]
mysql -u <db_user> -p <db_name> < my-script.sql

Export (mysqldump)

ssh [email protected]
mysqldump -u <db_user> -p <db_name> > backup-$(date +%F).sql

Import a dump

ssh [email protected]
# upload the .sql file via SFTP first, into ~/tmp/
mysql -u <db_user> -p <db_name> < ~/tmp/restore.sql

Connecting from a desktop GUI

MySQL is bound to localhost on our side and isn't exposed on the public internet — direct connections from your laptop are blocked by the firewall. The standard workaround is an SSH tunnel:

ssh -L 3307:localhost:3306 [email protected]
# leave that running; in another terminal or in TablePlus / DBeaver / Sequel Ace,
# point the connection at localhost:3307 with your db user + password

Tools that know about SSH tunnels (TablePlus, Sequel Ace, DBeaver, MySQL Workbench) can do all of this from a single connection panel — pick "MySQL over SSH" and supply the SSH credentials from your SFTP page alongside the database credentials.

Backups

Daily database backups are part of every plan and run automatically at 02:00 UTC. The Backups tab on your site detail page lists snapshots and lets you restore. For ad-hoc dumps outside that schedule, use the mysqldump command above and store the output wherever you keep your records — the file lands in your home directory and is included in the next snapshot.

What happened to phpMyAdmin?

v1 doesn't include a browser-based SQL UI. We're keeping the dashboard surface tight in v1 and pointing power users at the command line; a phpMyAdmin equivalent is on the v1.5 roadmap. Until then, the workflows above cover everything phpMyAdmin handled.

Need help?

If you can't connect, the database is locked, or a query is doing something unexpected, see troubleshooting or contact support with the exact error text and the SQL you ran.