Skip to Content
DocsApplicationsUtilitiesphpMyAdmin
phpMyAdmin

phpMyAdmin

Manage QuickBox databases through a browser: browse schemas, run queries, and adjust users without leaving the web UI.

Overview

phpMyAdmin in QuickBox is the packaged web database console installed and managed through qb, with nginx and PHP-FPM wired automatically. It is purpose-built for administering your existing QuickBox-managed databases through a browser.

It is not a database server or a replacement for backups; it sits on top of the database you already run.

Key features

The highlights below show what is provisioned for you when you install phpMyAdmin with qb.

⚡ One-command setup

Provision the latest stable phpMyAdmin, generate config, and restart PHP-FPM/nginx with qb install phpmyadmin.

🔐 Cookie auth + secret

Installer seeds a fresh blowfish secret and uses your QuickBox DB credentials for cookie-based authentication.

🌐 Reverse proxy ready

Nginx location for /phpmyadmin is created automatically with PHP-FPM passthrough and try_files safety.

🧩 Dashboard hooks

Shows under Database Management, with package controls and user process entries aligned to phpMyAdmin.

🛟 Safe updates

Update/reinstall keeps your stored DB host/user/pass and blowfish secret while refreshing the app files.

🔧 PHP extensions handled

Enables required PHP 8.1 modules (bz2, mbstring, zip, gd, curl, xml, mysql, intl, bcmath) during install.

When to use it

Use phpMyAdmin when you need a browser UI on the QuickBox database and want qb to maintain the nginx route, PHP modules, and configuration.

Symptoms

  • You need a browser UI to inspect QuickBox databases or run SQL without SSH.
  • Existing phpMyAdmin install is outdated or misconfigured after upgrades.
  • Users see login issues because DB credentials changed or the blowfish secret is missing.

Resolution

  • Install with qb install phpmyadmin to fetch the latest build and auto-generate a valid config.
  • Pass --pma-user / --pma-pass / --pma-host / --pma-port to align with custom database settings.
  • Update with qb update phpmyadmin to refresh files while preserving stored credentials and secrets.

Installation

Install phpMyAdmin from the QuickBox CLI; qb handles downloads, configuration, and nginx/PHP-FPM reloads.

Install from the QuickBox CLI

Admin-only package

Run installs from the QuickBox admin session. The installer uses your QuickBox database credentials by default and serves phpMyAdmin at /phpmyadmin behind nginx.

qb install phpmyadmin

Use flags when your database host, port, or credentials differ from the QuickBox defaults:

qb install phpmyadmin --pma-user dbuser --pma-pass 'strong-pass' --pma-host 127.0.0.1 --pma-port 3306

CLI command reference

The commands below cover install, update, reinstall, and removal. All preserve your stored DB settings unless you override them with flags.

CLI commands and flags

qb install phpmyadmin

Install the latest phpMyAdmin, enable required PHP 8.1 extensions, write config, and reload php-fpm/nginx.

qb install phpmyadmin --pma-user <user>

Override the DB username used for phpMyAdmin login (defaults to the QuickBox DB user).

--pma-pass <password>

Override the DB password stored in the generated phpMyAdmin config.

--pma-host <host>

Set the database host if not using the QuickBox default (commonly 127.0.0.1).

--pma-port <port>

Set a custom database port (defaults to the QuickBox DB port).

qb update phpmyadmin

Pull the latest phpMyAdmin release while preserving your DB credentials and blowfish secret.

qb reinstall phpmyadmin

Reinstall from scratch using the stored credentials, regenerating files and nginx location as needed.

qb remove phpmyadmin

Uninstall phpMyAdmin and clean up its nginx location block.

Access and authentication

URL / route

phpMyAdmin is served at /phpmyadmin through the generated nginx location block. Access it at http(s)://your-host/phpmyadmin after installation.

Login / credentials

Login uses the database credentials stored during installation. By default, qb writes your QuickBox DB host, user, and password into config.inc.php and configures cookie-based auth with a generated blowfish secret.

Security notes

  • Protect the route with HTTPS (pair with qb install lecert if you need Let’s Encrypt).
  • Restrict exposure to trusted networks; phpMyAdmin contains database access.
  • If you rotate DB credentials, reinstall or update with the new —pma-user / —pma-pass flags so the stored values stay current.

Configuration and files

Key paths below show where phpMyAdmin and its nginx location live. Use these when auditing configuration or cleaning up.

Key locations
phpMyAdmin deployment
/usr/share/phpmyadmin/# Application files and generated configuration
├── config.inc.php# Generated with cookie auth, DB host/user/pass, blowfish secret
└── tmp/# Temp directory created during install
/etc/nginx/software/# Package location blocks
└── phpmyadmin.conf# Serves /phpmyadmin via PHP-FPM with try_files guard

Common tasks

Routine maintenance is handled through qb; updates preserve stored credentials and the blowfish secret.

Updating / reinstalling

  • Update to the latest release while keeping configuration:
qb update phpmyadmin
  • Reinstall cleanly using the stored settings (or override with flags):
qb reinstall phpmyadmin
  • Remove when no longer needed and clean up the nginx location:
qb remove phpmyadmin

Typical workflows

  • Install with defaults, then browse databases at /phpmyadmin.
  • Install with custom DB host/user/pass using —pma-* flags when QuickBox is not managing your DB credentials.
  • After changing DB credentials, rerun qb install phpmyadmin (or update) with new flags to refresh config.inc.php.
  • Pair with Let’s Encrypt via qb install lecert to secure the route.

Best practices

Keep the deployment aligned with QuickBox defaults and avoid manual edits that the installer manages.

Do

  • Use qb install phpmyadmin instead of manual tarball installs so nginx, PHP modules, and config stay in sync.
  • Create a dedicated DB user with least privileges for phpMyAdmin access; rotate the password if you change database settings.
  • Protect the /phpmyadmin path with HTTPS (pair with qb install lecert for Let's Encrypt) and strong admin passwords.
  • Update regularly with qb update phpmyadmin to receive security fixes while keeping your stored credentials.

Don't

  • Do not edit generated config.inc.php by hand unless you know the phpMyAdmin directives being changed.
  • Avoid exposing /phpmyadmin publicly without HTTPS or firewall rules; it contains database credentials.
  • Do not reuse stale DB credentials after changing the QuickBox database host/user/pass—reinstall or update with new flags instead.

Troubleshooting

Common issues trace back to credentials, nginx routing, or missing PHP modules. Start with the checks below.

Login fails or loops

Symptom: Credentials are rejected or sessions loop.


Checks: Confirm the DB user/pass you supplied to qb are current; reinstall with updated —pma-user / —pma-pass; ensure the generated blowfish secret was not removed from config.inc.php.

404 or 502 on /phpmyadmin

Symptom: Route not found or upstream errors.


Checks: Verify /etc/nginx/software/phpmyadmin.conf exists; rerun qb install phpmyadmin or qb update phpmyadmin to recreate; reload nginx if you edited other site configs.

Missing PHP extensions

Symptom: phpMyAdmin reports missing modules.


Checks: Reinstall via qb so required PHP 8.1 modules (bz2, mbstring, zip, gd, curl, xml, mysql, intl, bcmath) are enabled; restart php-fpm if services were changed manually.

Resources

Further reading and related utilities.

Resources

phpMyAdmin documentation

Official user guide, configuration, and security notes.

phpMyAdmin releases

Latest stable versions fetched by the installer.

QuickBox Let’s Encrypt (lecert)

Secure your phpMyAdmin endpoint with HTTPS.

Join the Community

Media server operators sharing configs, getting support, and shaping the future of QuickBox Pro.

Dedicated Support
Feature Previews
Community Configs
Active Discussions
Join Discord Server
NetdataVPN (OpenVPN)