Managing databases

MyPanel manages real databases — MySQL, MariaDB, PostgreSQL, Redis — running either directly on the host (native) or in Docker.

Install a database engine

Go to Databases → Engines. Each engine shows its install status; click Install and MyPanel provisions it (systemd service or Docker image pull). With MYPANEL_SETUP=full, MySQL is already installed.

Create a database

1. Go to Databases → Add database.
2. Pick an engine and name the database.
3. MyPanel creates the database with a dedicated user + password (the user only has rights on that database) and shows the connection info (password hidden, click to reveal).

Connect from a website

Copy the connection info from the database detail page into your website’s environment variables, for example:

DATABASE_URL=postgres://shop_user:***@127.0.0.1:5432/shop

Tip

Databases listen on localhost only by default. To access from an external machine (e.g. a GUI client), open the port via an SSH tunnel rather than the firewall.

Backup & restore

Right on the database detail page:

• Backup — create a dump (mysqldump / pg_dump) stored at /var/lib/mypanel/backups/.
• Restore — restore from an existing backup.
• Download — download a backup file.
• Reset password — change the database user’s password.

Tip

The Pro plan adds scheduled automatic backups + remote (S3) storage and retention policies — see the pricing page.

Remote database servers

Besides databases on this server, you can connect to external database servers — MySQL, MariaDB, PostgreSQL and Oracle are supported.

Go to Databases → Remote servers → Add server, pick the engine and enter the connection details (host, port, admin account). Oracle also needs a Service name / SID. MyPanel tests the connection before saving and encrypts the admin password at rest. You can then create/drop databases on that server right from MyPanel.