Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

1 Answer

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 config.sample.inc.php to config.inc.php .

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
add comment

Your Answer

 
discard

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.