Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using a single Amazon RDS instance (medium) to power several WordPress websites running on a single Amazon EC2 instance.

I used to have my databases on another EC2 instance and installed phpMyAdmin there.
phpMyAdmin offers quite neat run time analysis.

Is there anyway I can gain such analysis providing that I'm using Amazon RDS for my databases?

share|improve this question
up vote 0 down vote accepted

This depends on your particular setup, but you just modify your phpmyadmin config file to connect to the RDS database, and use phpmyadmin as usual.

Go to the phpmyadmin's root folder (usually /var/phpmyadmin) and copy to .

Inside the file set up yout RDS connection:

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '<RDS host>';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Remember that the server where you are running phpmyadmin must have access to the RDS.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.