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:
|
1 |
$cfg['Servers'][$i]['host'] = 'localhost'; |
to
|
1 |
$cfg['Servers'][$i]['host'] = '<link found in (1)>'; |
That’s it!
One problem: Won’t work unless you specify the username and password for the MySQL server. You’ve set them up when first launching a MySQL DB Instance On RDS. Thanks for the post though, I’ve been at it for 3 days now.
You are correct, Tom. You definitely need to know a valid username and password.