Connect to Amazon RDS MySQL with phpMyAdmin

This guide assumes you have a working installation of phpMyAdmin. Go ahead and install and return when it is working, if you don’t.

Before you get started, gather your:

  • RDS Endpoint
  • Username  (view-able from Instance Actions> See Details> Configuration Details)
  • Password (modifiable from Instance Actions> Modify> Settings> New Master Password)


First, you will need to edit your file to add or edit your Servers.

By default it is located

  • Debian (& Raspbian): /etc/phpmyadmin/
  • Windows (using Wamp Developer C:\WampDeveloper\Tools\phpMyAdmin

Other possible locations:

  • /usr/share/phpMyAdmin
  • /usr/share/phpmyadmin

At the end of the file add your second server config:

  • Name your server in verbose field
  • Put your RDS Endpoint (without colon & port) in for host
  • Ensure your port matches (by default it is 3306)

If you wish to save your credentials in the config file:

  • Change auth_type to ‘config’
  • Enter your Username
  • Enter your Master Password

Save the file and open or refresh phpMyAdmin in your browser.  You do not need to restart your web server.

Test your configuration

It should look like this:




Helpful hints:

Find your RDS Endpoint (this goes in the host variable)



Ensure your IP is authorized in the security group

  • Security groups> Select your DB Security Group
  • To add your IP select “CIDRP/IP” from the connection type, make sure “CIDR/IP iof your current machine” is your machine’s IP
  • Click Authorize


  • Jordan

    This seems like a great idea but it is not working for me. I can’t get the Server Choice option to show up. Is there something else I could be missing?

    • Vilian Ivantchev

      what is your setup?

  • Gaurav Arya

    Can’t make it work on RHEL 7. IF I install mariadb, it works, but with rds, it doesn’t.

    Using nginx on rhel 7.3 with ec2 and rds. Want to make phpmyadmin work with rds but have not been able to do so.

  • Alena Subotina

    You can do this using dbForge Studio for MySQL as well.