phpMyAdmin gives you a friendly web interface to manage MariaDB/MySQL: browse tables, run queries, import/export data, and handle users—without living in the SQL CLI. From the left navigation, click phpMyAdmin. We’ll open it in a new tab on port 884 and sign you in automatically with a short-lived token.

Who can use it

• Root only from the panel. (Resellers and end-users don’t get direct phpMyAdmin SSO here.)

How the one-click login works

• When you click phpMyAdmin, the panel reads /root/.my.cnf (the root DB credentials) and drops a couple of short-lived cookies for phpMyAdmin to use.
• We immediately open https://<your-hostname>:884/ in a new tab and you land signed in.
• If you wait too long before the new tab loads, the token can expire—just click again.

Prerequisites (quick checklist)

• phpMyAdmin service: installed and running (enabled in Services → Database, and systemctl is-active phpmyadmin shows active).
• Port 884 open: firewall allows 884/tcp, and nothing else is bound there.
• SSL works: you can reach https://your-hostname:884/ (self-signed is OK, but your browser may prompt).
• /root/.my.cnf present: contains valid [client] user and password for MariaDB.

Common “blank tab” fixes

If the phpMyAdmin tab opens but shows a blank/white page, walk through these quick checks:

1. Service actually running?
   systemctl status phpmyadmin
   If it’s not active: systemctl restart phpmyadmin and review journalctl -u phpmyadmin -n 50.
2. Port reachable?
   ss -tlnp | grep :884 should show a listener, and curl -vk https://<HOST>:884/ should return HTML (ignore SSL warnings if self-signed).
3. Firewall allows it?
   On firewalld: firewall-cmd --add-port=884/tcp --permanent; firewall-cmd --reload.
4. Hostname vs. IP:
   Use the same host you use for the panel (e.g., server.example.com). If you open via raw IP and your browser blocks cookies or SSL, the page may appear blank. Try hostname first.
5. Token timing:
   The SSO cookies are intentionally short-lived. If your network is slow, simply click phpMyAdmin again to refresh the token.
6. Root DB creds available:
   Ensure /root/.my.cnf has:

   [client]
   user=root
   password=YOUR_DB_PASSWORD

   and that you can run mysql -e "SELECT 1" as root on the server.
7. Look at phpMyAdmin logs:
   Check /opt/shm/phpmyadmin/logs/ (and webserver logs) for PHP errors or missing extensions.

Security tips

• Keep phpMyAdmin disabled if you don’t need it; enable when needed via Services.
• Restrict access to port 884 in your firewall to trusted IPs.
• Rotate the DB root password if you suspect it’s stale or leaked.