Overview
What's Included
- MySQL 8.0, 8.4, or 9.0 (choose your version)
- phpMyAdmin web interface
- SSL/TLS encryption enabled
- Auto-generated secure credentials
- Performance tuning for instance size
- Separate EBS data volume
- S3 backup scripts included
Step-by-Step Guide
1
Launch the AMI
Choose your MySQL version and OS combination from AWS Marketplace.
# Available versions:
# MySQL 8.0 - Stable, widely supported
# MySQL 8.4 - Latest LTS with new features
# MySQL 9.0 - Cutting edge
# OS options: Ubuntu 24.04/22.04, Amazon Linux 2023,
# AlmaLinux 10, Rocky Linux 10
2
Get Your Credentials
Retrieve the auto-generated MySQL root password and phpMyAdmin URL.
ssh -i your-key.pem ubuntu@your-instance-ip
# View all credentials
sudo cat /opt/flowops/credentials.txt
# Contents include:
# - MySQL root password
# - phpMyAdmin URL
# - Instance connection details
3
Access phpMyAdmin
Open your browser and log into the web interface.
# phpMyAdmin URL
http://your-instance-ip/phpmyadmin
# Login with:
# Username: root
# Password: (from credentials.txt)
# Or connect via CLI:
mysql -u root -p
4
Create Database and User
Set up your application database with proper permissions.
-- Create a database
CREATE DATABASE myapp CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- Create application user (never use root in production!)
CREATE USER 'appuser'@'%' IDENTIFIED BY 'strong_password_here';
GRANT ALL PRIVILEGES ON myapp.* TO 'appuser'@'%';
FLUSH PRIVILEGES;
-- Verify
SHOW DATABASES;
SELECT user, host FROM mysql.user;
Comparison
| Feature | This AMI | RDS MySQL | Self-Install |
|---|---|---|---|
| Setup Time | 5 minutes | 10 minutes | 1+ hour |
| phpMyAdmin | Included | Not available | Manual setup |
| SSL/TLS | Pre-configured | Pre-configured | Manual |
| Cost (m5.large) | ~$70/month | ~$140/month | ~$70/month |
| Backups | S3 scripts | Automated | Manual |
Use Cases
- WordPress and CMS hosting
- Web application backends
- E-commerce platforms
- SaaS applications
- Development/staging environments
- Legacy application hosting
Pricing
Our AMIs are available on AWS Marketplace with simple hourly pricing:
- Software: $0.10-0.15/hour (varies by product)
- EC2: Standard AWS pricing for your chosen instance
- Support: 24/7 included with guaranteed 24-hour response
Need Help?
Our UK-based support team is here to help you get the most out of your deployment. Email us at support@flowopsconsulting.co.uk for any questions.
Comments