Self-host MySQL with phpMyAdmin on a VPS
A MySQL 8.4 server paired with the phpMyAdmin web console, already wired together. The database is not published on the host, so other services in this project reach it at db:3306. Sign in to phpMyAdmin as root with the generated root password.
levelrail-cli templates install mysql-phpmyadmin --name my-mysql-phpmyadminSpecification
- Status
- Listed
- Category
- Database Tools
- Services
- db, phpmyadmin
- Ports
- 80
- Volumes
- 1
- Memory
- about 768 MiB
- arm64
- unknown
- amd64
- unknown
- Settings to fill in
- none
- Listing
- Community template
About MySQL with phpMyAdmin
A MySQL 8.4 server paired with the phpMyAdmin web console, already wired together. The database is not published on the host, so other services in this project reach it at db:3306. Sign in to phpMyAdmin as root with the generated root password.
What it deploys
MySQL with phpMyAdmin runs as 2 services in a single Compose app, listening on port 80, with 1 named volume mount.
| Service | Image | Tag | Ports | Volumes |
|---|---|---|---|---|
| db | mysql | 8.4.13 | none | mysql_data -> /var/lib/mysql |
| phpmyadmin | phpmyadmin | 5.2.3 | 80 | none |
Before you install
- CPU architecture. arm64 unknown. The scan could not read a manifest or the tag is chosen at install time. This is not a claim either way.
- Listed. It is in the catalog. Back up the data volume before changing an image tag.
Settings and environment
You do not have to fill in anything. 1 secret is generated at deploy and stored encrypted. Values are never shown here.
| Service | Variable | Value |
|---|---|---|
| db | MYSQL_ROOT_PASSWORD | Generated at deploy |
| phpmyadmin | PMA_HOST | Preset by the template |
| phpmyadmin | PMA_PORT | Preset by the template |
First run
- Open the page and sign in as root with the generated root password from the app secrets.
Install MySQL with phpMyAdmin on a VPS
-
Install Levelrail on a fresh VPS
Run this as root on a Linux server (amd64 or arm64) with ports 80 and 443 reachable. The installer prints a setup link.
curl -fsSL https://levelrail.com/install.sh | sudo sh -
Sign in
Open the setup link, choose a password, then log the CLI in. The CLI install command is
curl -fsSL https://levelrail.com/install-cli.sh | shif the machine does not have it. See Getting started.levelrail-cli login --device -
Read the template
Shows the entry, including its full compose.yaml.
levelrail-cli templates get mysql-phpmyadmin -
Install it
This template has an install form, so the CLI fills each setting from --env, a generated secret or its default.
levelrail-cli templates install mysql-phpmyadmin --name my-mysql-phpmyadminTo put a service behind a domain at install, add
--domain SERVICE=HOST:levelrail-cli templates install mysql-phpmyadmin --name my-mysql-phpmyadmin --domain db=mysql-phpmyadmin.example.com
Without a domain the app gets an sslip.io address. You can also deploy it from the dashboard: Apps, New app, Browse templates, then MySQL with phpMyAdmin.
Docs and upstream
More in Database Tools
- MySQLThe MySQL Community database server on the official image, with a persistent volume, generated root and user passwords, and an application database. It is not published on the host, so reach it from other services in this project at mysql:3306.
- MongoDBThe MongoDB document database on the official image, with a persistent volume and a generated root user and password. It is not published on the host, so reach it from other services in this project at mongodb:27017.
- Neo4jA graph database with the Cypher query language, Community Edition, including the browser console.
- Mongo ExpressA web admin console for MongoDB, bundled with its own MongoDB 7 instance and basic auth.
- MilvusA cloud-native vector database built for billion-scale similarity search, run here as a single standalone node. Has no authentication, so reach it from other services in this project at milvus:19530, or attach a domain (it routes to port 19530 only) only behind Basic Auth. Not published on the host.
- NocoDBTurn any database into a smart spreadsheet, with a real-time collaborative grid UI.