AppXen MySQL Stack provides a fully-integrated, containerized MySQL 5.7 environment with Adminer for web-based administration. Everything is containerized on EC2 for portability with persistent docker volumes on disk. It also includes Adminer for light weight web-based administration of the database.
AWS CONFIGURATION
When launching your instance, provide the following security group rules:
- TCP, 22, 22, YOUR-IP-ADDRESS*
- TCP, 3306, 3306, EXTERNAL-SERVER-CONNECTING**
- TCP, 8080, 8080, YOUR-IP-ADDRESS*
* Always lock-down the SSH port to a single IP address. Opening your SSH port to the world i.e. `0.0.0.0/0` is a security risk and can compromise your instance.
** If you want an external server to connect to MySQL, add the IP address here, you shouldn't leave this open to the world since it opens up security vulnerabilities to the database instance. You can also leave this rule out if you want to simply use the database locally on the same server instance. This is only required if you want an external server connecting to the instance.
When logging into the Adminer web interface (port 8080 by default on your EC2 provided DNS), use the following information:
- Visit the EC2 provided DNS i.e. http://ec2-provided-dns.amazonaws.com:8080
- Select MySQL from the drop down System drop-down
- Username: admin
- Password: {Auto-generated on first boot, see below for details}
- Database: db
CREDENTIALS AND PASSWORDS
All AppXen instances auto-generate passwords upon first boot. You can locate the credentials within the EC2 console. Right click on your instance and view the instances system log, you will find the docker stack output that contains auto-generated passwords in the log (see below for example), from which you can copy/paste, and login to web administration applications.
Once you have the password, you can login to the web application server on the defined port (8080 for example) of your instance to manage your application server.
IMPORTANT: The credentials are available in the system log for the first 24 hours after you first start the instance. It is strongly recommended that you note it down immediately after startup and save it in a safe place, as you will be unable to access the web-based software without it. We also recommend that you change it as soon as possible for security reasons.