Isn’t it annoying how you can’t ssh in to Amazon RDS instances? Don’t you wish there was a way you could use trusty old phpMyAdmin to manage your db? Here is the easy way to do it:
- Find the endpoint link to your RDS server. It’s found in the instance information section. It usually looks something like this: xxx.amazonaws.com
- Install phpMyAdmin somewhere. I recommend on a webserver so you can access anywhere.
- cd phpMyAdmin
- sudo cp -p config.sample.inc.php config.inc.php
- Change this line in config.inc.php:
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['host'] = '<link found in (1)>';