phpMyAdmin

Temporary browser access to managed MySQL on Bahriya with phpMyAdmin: HTTPS, restricted to your IP allowlist, and switched off automatically.

Updated 22 Oct 20261 min read

Sometimes you just need to look at a table. Each MySQL instance can run phpMyAdmin, the browser-based MySQL client, for exactly that — over HTTPS, restricted to your IP allowlist, and switched off again automatically.

Turning it on

Enable phpMyAdmin on the instance in the console, or set it from the CLI or Terraform:

reis mysql:update <instance-id> --phpmyadmin --phpmyadmin_ttl 4 --allowed_ips 198.51.100.7/32
clientenabled  = true
clientttlhours = 4
allowedips     = ["198.51.100.7/32"]

phpMyAdmin requires a non-empty IP allowlist; the platform rejects the change otherwise. It shares the instance's allowlist with external access.

Where it lives

One address per region:

https://pma-<default-hostname>.<region>.mysql.on.bahriya.app

The instance's detail page lists them. Sign in with a database user and its password — your application's user sees its own database; root sees everything.

It switches itself off

phpMyAdmin is meant for a session of work, not as a permanent fixture. It runs for the number of hours you set — 1 to 168, 24 if you do not say — and then the platform turns it off. Turn it on again whenever you need it. You can also turn it off yourself at any time.

Good practice

  • Allowlist the narrowest range you can — ideally a single address.
  • Prefer a database user over root.
  • For anything you do repeatedly — reports, exports, migrations — use a client on a machine you control with external access, or a container in the project.