Adminer

Full-featured PHP database management tool in a single deployable file.

Access

  • Open Adminer in your browser: https://<server-ip>/adminer
  • Accept SSL warning (self-signed certificate).
  • Login using the Basic Auth credentials stored in /root/.cloudzy-creds.

Database Access (Optional MySQL)

If MySQL was installed, database connection info, including the root password, is stored in /root/.cloudzy-creds

Important Files & Directories

  • /etc/apache2/sites-available/adminer.conf → Apache virtual host for Adminer
  • /etc/apache2/ssl/ → SSL certificate and private key
  • /etc/apache2/.htpasswd → Basic HTTP Auth file
  • /var/log/apache2/ → Access and error logs
  • /root/.cloudzy-creds → Saved credentials

Managing Services

systemctl restart apache2       # Restart Apache
systemctl status apache2        # Check Apache status
mysql -u root -p                # Connect to MySQL (if installed)

Notes

  • All HTTP traffic (port 80) is redirected to HTTPS (port 443)
  • Basic HTTP authentication is required to access Adminer

Application Details