COG - phpMyAdmin: MySQL and MariaDB Database Administration Tool

Manage your MySQL, MariaDB, and Amazon Aurora databases from any browser - no SSH tunnels, no CLI complexity. This pre-configured phpMyAdmin AMI from Cloud Ops Group gives DevOps engineers, full-stack developers, and database administrators instant web-based access to their AWS-hosted databases.

Key Features

Intuitive Web Interface - Navigate databases, tables, columns, relations, indexes, and users through a clean graphical UI without memorizing command-line syntax
Multi-Server Administration - Centrally manage multiple MySQL and MariaDB servers from a single phpMyAdmin instance
Database Schema Visualization - View graphical representations of your database structure to understand relationships at a glance
Query-by-Example (QBE) - Build complex queries visually without writing raw SQL, ideal for rapid data exploration
Global Database Search - Search across tables, columns, or entire databases to quickly locate data
SQL Execution and Bookmarking - Execute, edit, and bookmark SQL statements including batch queries for repeatable workflows
Import/Export in Multiple Formats - Move data in and out of your databases for migrations, backups, and cross-environment transfers
Stored Procedures and Triggers - Manage stored procedures and triggers directly from the web interface
User and Privilege Management - Create and manage MySQL user accounts and permissions without command-line access
Server Maintenance Suggestions - Receive configuration suggestions for optimizing your database server performance
Custom Data Transformations - Apply transformations to stored data for display and processing

Who This AMI Is For

This AMI is designed for teams running MySQL, MariaDB, or Amazon Aurora on AWS who need quick, secure database visibility without manual phpMyAdmin installation and configuration. Whether you are a solo developer inspecting an RDS instance, a DevOps team needing rapid troubleshooting access, or a DBA consolidating multi-server management, this AMI provides a ready-to-use solution.

Example Use Case

A development team running an Aurora cluster needs to inspect production data, modify table schemas, and export datasets for local testing - all without configuring SSH tunnels or installing local database clients. After launching this AMI, they access phpMyAdmin through their browser, connect to their Aurora endpoint, and begin working within minutes.

AWS Integration

This AMI connects to Amazon RDS for MySQL, Amazon RDS for MariaDB, and Amazon Aurora MySQL-compatible databases. Launch the instance in the same VPC as your database endpoints for optimal connectivity and security.

Getting Started

Launch AMI from the Amazon Marketplace
Open a Web browser and type the public DNS name provided by Amazon into the URL bar.
COG - phpMyAdmin does not install a local database so you'll need to enter the Database server, username, and password for an existing MySQL, MariaDB, or Aroura RDS server. You can gather this information from the RDS console or from your Database Administrator.
See: phpMyAdmin User Guide to get started using phpMyAdmin.

Requirements and Limitations

Domain registration and DNS configuration are not included.
Email delivery service (e.g., Amazon SES) must be configured separately.
Managed backups are the customer's responsibility (consider AWS Backup or snapshots).
SSL/TLS is not configured by default. It's recommended to place instance behind load balancer or CloudFront.

Security and Maintenance

Cloud Ops Group maintains this product with a focus on security and reliability. The image receives regular updates that include:

Kernel patches and security fixes.
Package updates for included runtimes.
System utility updates for stability and performance.

The image is built with a minimal package set to reduce the attack surface compared to full-featured desktop distributions

Support

For bug reports, feature requests, or general questions, please contact us.