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?