Manage Amazon RDS with phpMyAdmin via EasyEngine

This article explains the configuration for  phpMyAdmin installed via EasyEngine for AWS RDS  instance.

PreRequisites:

  1. Amazon RDS instance setup and configure with proper security group.
  2. EasyEngine installed server.

Install MySQL client

apt-get update
apt-get install mysql-client

Configure Mysql Credentials

Your mysql credentials file should look like following to use your Amazon RDS  with EasyEngine.

vim /etc/mysql/conf.d/my.cnf

[client]
host=xxxx.xxxxxx.xxxx.rds.amazonaws.com
user=<REMOTE_MYSQL_USER>
password=<REMOTE_MYSQL_PASSWORD>

Change permissions of file  /etc/mysql/conf.d/my.cnfto 600 .  So that only user with sudo privileges can access your database.

sudo chmod 600 /etc/mysql/conf.d/my.cnf

Install phpMyAdmin

Install phpMyAdmin via EasyEngine command.

ee stack install --pma

Above command will install and configure phpMyAdmin for Amazon RDS instance.

You can see phpMyAdmin athttps://example.com:22222/db/pma/