Self-host MySQL on a VPS
The 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.
levelrail-cli templates install mysql --name my-mysqlSpecification
- Status
- Listed
- Category
- Database Tools
- Services
- mysql
- Ports
- 3306
- Volumes
- 1
- Memory
- about 768 MiB
- arm64
- unknown
- amd64
- unknown
- Settings to fill in
- none
- License
- Copyleft license, GPL-2.0-only
- Listing
- Community template
About MySQL
The 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.
What it deploys
MySQL runs as one service in a single Compose app, listening on port 3306, with 1 named volume mount.
| Service | Image | Tag | Ports | Volumes |
|---|---|---|---|---|
| mysql | mysql | 8.4.13 | 3306 | mysql_data -> /var/lib/mysql |
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. 2 secrets are generated at deploy and stored encrypted. Values are never shown here.
| Service | Variable | Value |
|---|---|---|
| mysql | MYSQL_DATABASE | Preset by the template |
| mysql | MYSQL_PASSWORD | Generated at deploy |
| mysql | MYSQL_ROOT_PASSWORD | Generated at deploy |
| mysql | MYSQL_USER | Preset by the template |
First run
- Read the generated passwords from the app secrets, then connect with the application user or as root from a service in the same project.
Install MySQL 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 -
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 --name my-mysqlTo put a service behind a domain at install, add
--domain SERVICE=HOST:levelrail-cli templates install mysql --name my-mysql --domain mysql=mysql.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.
Docs and upstream
More in Database Tools
- MySQL with phpMyAdminA 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.
- 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.
- Mongo ExpressA web admin console for MongoDB, bundled with its own MongoDB 7 instance and basic auth.
- Neo4jA graph database with the Cypher query language, Community Edition, including the browser console.
- 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.
- MemcachedA fast in-memory cache for query results, sessions and rendered pages, reachable by other apps on host memcached.