Can't connect to phpmyadmin in Bitnami instance hosted by AWS
When looking at this article (How to enable phpMyAdmin or phpPgAdmin to be accessed remotely?), I needed to be looking at Virtual Machine and not Amazon cloud / Bitnami Hosting.
When I changed the /opt/bitnami/apps/phpmyadmin/conf/httpd-app.conf
file to the following, I was able to access via [PUBLIC_DNS/YOUR_DOMAIN_NAME/IP]/phpmyadmin].
Main changes being:
Allow from all
and
Require all granted
After the changes, remember to restart apache server. (or reboot your instance)
sudo /opt/bitnami/ctlscript.sh restart apache
/opt/bitnami/apps/phpmyadmin/conf/httpd-app.conf
<Directory "/opt/bitnami/apps/phpmyadmin/htdocs">
# AuthType Basic
# AuthName phpMyAdmin
# AuthUserFile "/opt/bitnami/apache2/users"
# Require valid-user
AllowOverride None
<IfModule php5_module>
php_value upload_max_filesize 80M
php_value post_max_size 80M
</IfModule>
<IfVersion < 2.3 >
Order allow,deny
Allow from all
Satisfy all
</IfVersion>
<IfVersion >= 2.3>
Require all granted
</IfVersion>
ErrorDocument 403 "For security reasons, this URL is only accesible using localhost (127.0.0.1) as the hostname"
</Directory>
Docs Ref: https://docs.bitnami.com/virtual-machine/components/phpmyadmin/
I faced the same issue. Though I was able to access phpMyAdmin by using the following steps
SSH to the server using the following command
ssh -N -L 8888:127.0.0.1:80 -i YourPemFile.pem bitnami@YourServerIP
Then open the following link in your browser
http://127.0.0.1:8888/phpmyadmin
You will see the following page
Now just use root and the default wordpress password to login.