HailBytes MySQL Stack provides a fully-integrated MySQL 5.7 environment with Adminer for web-based administration. Everything is in one EC2 for portability with persistent storage via EBS. Adminer is a PHP-based database management tool that is widely used as an alternative to PHPMyAdmin.

Usage Instructions:
Once you start up the server, Adminer and MySQL will automatically configure.

The adminer_cloud_conf.service will generate certificates, create DNS entries, and update your administrative account for MySQL.

Access the Web UI at https://.youradminer.com/adminer

MySQL Access:
System: MySQL
Server: localhost
Username: admin
Password:
Database:

Once you login, you can begin defining tables and schemas to start using your Adminer instance immediately.

You can check the health of the Adminer service at any time while connected to the server via SSH with the following command:
systemctl status apache2.service
systemctl status adminer_cloud_conf.service
systemctl status mysql.service

You will need to make sure that if you have any firewalls in your environment (security groups) that the required ports 443, 80, and 22 are open.

Ports which encrypt traffic have been added to the security groups by default, these can be restricted to your network if access will only be made by users on that network or on a VPN connecting to that network.

Port 80 is open in order to allow for automatic certificate generation and renewal by acme.sh.

If you require a VPN for managing connections to your network, please refer to our HailBytes VPN listing for a VPN 4-6x faster than OpenVPN.