• MariaDB
• Web Control Panel
• Adminer administration frontend for MySQL (listening on port 12322 – uses SSL).
• MySQL webmin module.
• MySQL is configured to listen on port 3306 TCP on all interfaces by default.
• For convenience MySQL is configured to accept connections from all hosts by default. In a production environment it is recommended to limit incoming connections to specific hosts:

  UPDATE `mysql`.`user` SET `Host` = 'hostname'
  WHERE CONVERT( `user`.`Host` USING utf8 ) = '%' AND
  CONVERT( `user`.`User` USING utf8 ) = 'adminer' LIMIT 1 ;
  

Note: MySQL can be further tweaked to optimize performance.

Ignore SSL browser warning: browsers don’t like self-signed SSL certificates, but this is the only kind that can be generated automatically. If you have a domain configured, then via Confconsole Advanced menu, you can generate free Let’s Encypt SSL/TLS certificates.

Web – point your browser at either:

1. http://12.34.56.789/ – not encrypted so no browser warning
2. https://12.34.56.789/ – encrypted with self-signed SSL certificate

Note: some appliances auto direct http to https.

Username for database administration:

1. Adminer; login as MySQL username adminer:https://12.34.56.789:12322/ – Adminer database management web app
2. MySQL command line tool; log in as root (no password required):

   $ mysql --user root
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   
   mysql>
   

Username for OS system administration:

Login as root

1. Point your browser to:
   • https://12.34.56.789:12321/ – System control panel
   • https://12.34.56.789:12320/ – Web based command line terminal
2. Login with SSH client:

   ssh [email protected]
   

* Replace 12.34.56.789 with a valid IP or hostname.