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 phpmyadminto fetch the latest build and auto-generate a valid config. - Pass
--pma-user/--pma-pass/--pma-host/--pma-portto align with custom database settings. - Update with
qb update phpmyadminto refresh files while preserving stored credentials and secrets.
Installation
phpMyAdmin is an admin-installed, server-wide utility. Installing it provisions the latest stable build, enables the required PHP modules, writes the config with cookie auth and a fresh blowfish secret, and serves it at /phpmyadmin behind nginx.
Install from the Dashboard
Open App Dashboard → Package Management (/dashboard?mode=packages), find phpMyAdmin in the catalog (it lists under Database Management), and click Install. The install uses your QuickBox database credentials by default. Reinstall, Update, and Remove are on the same panel, and all preserve your stored DB host/user/pass and blowfish secret. phpMyAdmin is admin-only — see App Management for the full flow.
Install from the CLI (automation)
The CLI runs the same installer and is suited to scripting:
qb install phpmyadmin
qb update phpmyadmin
qb reinstall phpmyadmin
qb remove phpmyadminIf your database host, port, or credentials differ from the QuickBox defaults, the CLI accepts override flags that the standard install does not prompt for: —pma-user, —pma-pass, —pma-host, —pma-port. Use these when QuickBox is not managing your DB credentials:
qb install phpmyadmin --pma-user=dbuser --pma-pass='strong-pass' --pma-host=127.0.0.1 --pma-port=3306Commands and install options
qb install phpmyadminFetch the latest stable phpMyAdmin, auto-generate config, and restart PHP-FPM/nginx.
qb update phpmyadminRefresh files to the latest build while preserving stored credentials and the blowfish secret.
qb reinstall phpmyadminRe-run the installer and regenerate config.
qb remove phpmyadminRemove phpMyAdmin and clean up its nginx location block.
--pma-user=<user>Database user written into config.inc.php (overrides the QuickBox default).
qb install phpmyadmin --pma-user=dbuser--pma-pass=<password>Database password for the supplied user.
qb install phpmyadmin --pma-pass='strong-pass'--pma-host=<host>Database host (overrides the QuickBox default).
qb install phpmyadmin --pma-host=127.0.0.1--pma-port=<port>Database port (overrides the QuickBox default).
qb install phpmyadmin --pma-port=3306Full flag reference: CLI Reference.
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 lecertif 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-passflags 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.
Common tasks
Routine maintenance runs from the dashboard Package Management panel (or the CLI). Update, reinstall, and remove all preserve stored credentials and the blowfish secret.
- Browse databases at
/phpmyadminafter install. - Custom DB credentials — if QuickBox is not managing your DB credentials, reinstall from the CLI with the
--pma-*flags to refreshconfig.inc.php(see the Installation note above). - After rotating DB credentials, reinstall (CLI with new
--pma-*flags, or the dashboard Reinstall for QuickBox-managed defaults) so the stored values stay current. - Secure the route by pairing with Let’s Encrypt for HTTPS.
Best practices
Keep the deployment aligned with QuickBox defaults and avoid manual edits that the installer manages.
Do
- Use
qb install phpmyadmininstead 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 lecertfor Let's Encrypt) and strong admin passwords. - Update regularly with
qb update phpmyadminto 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.
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.
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.
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
Join the Community
Media server operators sharing configs, getting support, and shaping the future of QuickBox Pro.