Skip to content
Get started

phpMyAdmin on a VPS

Web interface for MySQL

Install on a VPSGitHub
Category
Databases
Hosting
Databases
Author
phpMyAdmin project
License
GPL-2.0
Version
5.2.3

The script is free · VPS from $2.79 per month · installs in about 45 seconds

Install over SSH

root@vps:~# command -v docker >/dev/null || curl -fsSL https://get.docker.com | sh; docker run -d --name phpmyadmin --restart unless-stopped -p 8080:80 -e PMA_ARBITRARY=1 phpmyadmin

  • SystemUbuntu 24.04 · x86_64ok
  • Sourcegithub.com/phpmyadmin/phpmyadminok
  • Version5.2.3ok
  • Port8080/tcplisten

✓ phpMyAdmin 5.2.3 installed · about 45 seconds

root@vps:~#

Install command from the library. Output is shortened and may differ on your server.

What it is

  • MySQL
  • MariaDB
  • Web interface
  • SQL

phpMyAdmin is a web interface for managing MySQL and MariaDB: tables, queries, dump import and export, users and permissions right from your browser.

Handy when you need to quickly look at a bot's or site's data, run an SQL query or upload a dump without the console.

The command runs the official image in a mode where the database server address is entered on the login page.

  • View and edit tables
  • SQL queries with syntax highlighting
  • Dump import and export
  • User and permission management
  • Work with multiple servers

Recommended plan

For phpMyAdmin: at least 1 vCPU, 2 GB RAM and 10 GB NVMe.

Minimum to run
1 vCPU · 1 GB RAM · 10 GB disk
Systems
Ubuntu 22.04 · Ubuntu 24.04 · Debian 12

How to install

Three steps in the bot or one command over SSH; installation takes about 45 seconds.

  1. 01

    Choose a plan in the bot

    Open @ExpressHost_bot and pay for a VPS. The server will be ready in about 60 seconds.

  2. 02

    Add phpMyAdmin

    At the “Add-ons” step pick the script from the library, or run it later: Server settings → Scripts.

  3. 03

    Finish the setup

    To connect to a database in a container, put them on the same network: docker network create db; docker network connect db mysql; docker network connect db phpmyadmin

Manually over SSH

Connect to the server as root and run the command. Supported systems: Ubuntu 22.04, Ubuntu 24.04, Debian 12.

Install command
command -v docker >/dev/null || curl -fsSL https://get.docker.com | sh; docker run -d --name phpmyadmin --restart unless-stopped -p 8080:80 -e PMA_ARBITRARY=1 phpmyadmin

Ports

phpMyAdmin ports
PortProtocolPurpose
8080tcpWeb interface

After installation

  1. 1.To connect to a database in a container, put them on the same network: docker network create db; docker network connect db mysql; docker network connect db phpmyadmin
  2. 2.Open http://server-IP:8080 and enter the server mysql (the container name), username and password
  3. 3.Close port 8080 to other IPs or put an HTTPS proxy with a password in front of it

phpMyAdmin FAQ

Didn’t find an answer? Message @ExpressHost_SupportBot.

Is it safe to keep phpMyAdmin publicly accessible?

Bots scan for it constantly. Allow access only from your IP or via an SSH tunnel: ssh -L 8080:127.0.0.1:8080 root@IP.

How do I update it?

docker pull phpmyadmin and re-create the container — it holds no data.

Does it work with PostgreSQL?

No, use pgAdmin for PostgreSQL.

phpMyAdmin installs at checkout — in the bot.

Install phpMyAdminBuy in Telegram