Mysql – installing phptheadmin for remote db host

amazon ec2amazon-web-servicesMySQLrds

I am having trouble trying to install phpmyadmin. We are using AWS services for our servers. Our mysql db is located in an RDS instance. Now I am trying to install phpmyadmin on an EC2 instance.

I have installed mysql-client on the EC2 instance. When I try to install phpmyadmin, the install dialog prompts me to create a database for phpmyadmin, asking me the root user credentials.

The problem is, by default the install dialog is trying to log into the database instance at localhost, which does not exists because our db instance is on a remote RDS instance.

I can skip this step and install phpmyadmin, make the necessary configurations and login to the db instance on RDS, but can not execute queries because of the missing phpmyadmin table.

How can I get the phpmyadmin install dialog to use the db instance on RDS by default?

Best Answer

That dialog comes from apt-get attempting to make your configuration easy for you, but it seems to assume you're installing to a database on the local machine. In this case, you should say no to that dialog; you'll have to manually configure the "phpMyAdmin Configuration Storage". Even though the dialog says you "must" have the database installed, I don't think that's true. It's certainly not true with the official release; it works perfectly fine without configuring those advanced features.

Once you install phpMyAdmin through apt-get, you'll need to edit the configuration file to point to the RDS database hostname or IP address. I'm pretty sure you'll find the configuration in /etc/phpmyadmin/.

Once you've gotten phpMyAdmin installed, you can use the documentation in /usr/share/doc/phpmyadmin to create the database manually (you'll most likely log in through phpMyAdmin and upload the file), but again, I don't think that's needed at all.

What I would do, however, is just download the source from http://www.phpmyadmin.net/ and uncompress it yourself in to your web root folder (which is likely /var/www/) and configure it manually. That way you're not confusing apt-get.

Hope this helps get you on your way.

Related Solutions

Mysql – Poor performance on Amazon RDS instance

One of the things that we ran into with a small RDS instance was the # of connections setting. It's a formula based on RAM - and it only allows ~ 150 connections on a small DB. That's the first thing that I would look at.

SHOW PROCESSLIST;

would be the command. If you are not using some sort of connection pooling in your app, I could see hitting that limit fairly quickly.

Just a shot in the dark, but good luck anyways!

AWS RDS – MySQL Slowing Down Over Time

T2 and T3 instances (incl db.t2 db.t3 instances) use CPU Credit system. When the instance is idle it accumulates CPU Credits that it can then use to run faster for short periods of time - Burst performance. Once you deplete the credits it slows down to a Baseline performance.

One option is to enable T2/T3 Unlimited setting in your RDS config which will let the instance run at full speed for as long as needed, but you will pay for the extra credits needed.

The other option is to change the instance type to db.m5 or some other non-T2/T3 type that supports consistent performance.

Here is a more in-depth explanation of the CPU credits and how they are accrued and spent: On clarifying t2 and t3 working conditions?

Hope that helps :)

Best Answer

Related Solutions

Mysql – Poor performance on Amazon RDS instance

AWS RDS – MySQL Slowing Down Over Time

Related Topic