Setting phpMyAdmin to point to an Amazon RDS instance

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:

  1. 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
  2. Install phpMyAdmin somewhere.  I recommend on a webserver so you can access anywhere.
  3. cd phpMyAdmin
  4. sudo cp -p config.sample.inc.php config.inc.php
  5. Change this line in config.inc.php:

to

 

That’s it!

2 thoughts on “Setting phpMyAdmin to point to an Amazon RDS instance

  1. 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.

Leave a Reply to admin Cancel reply

Your email address will not be published. Required fields are marked *