Can't connect to phpmyadmin in Bitnami instance hosted by AWS

Question

I'm trying to connect to phpmyadmin through my Public DNS and I can't seem to get it to work.

I've tried following these directions:

Can't Access PHPMyAdmin

By default phpMyAdmin is restricted to localhost. If you want it to be accessible from anywhere you should follow the steps described in “How to enable phpMyAdmin or phpPgAdmin?” in virtual machines FAQ:

SSH to the instance Replace the line “Allow from 127.0.0.1” with “Allow from all” in the file /opt/bitnami/apps/phpmyadmin/conf/phpmyadmin.conf Restart apache: sudo /opt/bitnami/ctlscript.sh restart apache

The problem with this solution is that I don't have a phpmyadmin.conf file in that directory. I found this pertaining to that Phpmyadmin.conf does not exist in the phpmyadmin folder, but that didn't allow me to access.

Check the /opt/bitnami/apps/phpmyadmin/htdocs/config.inc.php and change the “$cfg[‘PmaAbsoluteUri’]” option with your URL.

I'm still getting the same For security reasons, this URL is only accesible using localhost (127.0.0.1) as the hostname error and it's driving me mad.

Any ideas? If needed, I can readily post relevant content from configuration files.

Answer 1

I faced the same issue. Though I was able to access phpMyAdmin by using the following steps

1. SSH to the server using the following command

   ssh -N -L 8888:127.0.0.1:80 -i YourPemFile.pem bitnami@YourServerIP

2. Then open the following link in your browser

   http://127.0.0.1:8888/phpmyadmin

3. You will see the following page

4. Now just use root and the default wordpress password to login.