Unable to configure phpmyadmin

I used PHPMyAdmin for sometime until I realized that a web based app with full access to the database is probably not a good security practice. I started using MySQL Workbench over SSH and made sure the external MySQL port was closed for added security.

Unfortunately, that's all the help I can offer. I was using Apache and PHPMyAdmin and it just worked on Ubuntu when I installed the packages.

@The Other Air Force:

I used PHPMyAdmin for sometime until I realized that a web based app with full access to the database is probably not a good security practice. I started using MySQL Workbench over SSH and made sure the external MySQL port was closed for added security.

Unfortunately, that's all the help I can offer. I was using Apache and PHPMyAdmin and it just worked on Ubuntu when I installed the packages.

This is my advice. When I used PHPmyAdmin, I had an IP whitelist in .htaccess on the directory the symlink was in. It can be tedious, but learning SQL and using the MySQL shell is best.

sudo nano /srv/www/monjardeal.com/public_html/phpmyadmin/.htaccess

order allow,deny

Allow from All

is the content of my .htaccess file. but still phpmyadmin is not opening in browser window. When i open 212.71.255.110/phpmyadmin link this redirects me to https://212.71.255.110/phpmyadmin/?coll … ral_ci&SID">https://212.71.255.110/phpmyadmin/?collationconnection=utf8general_ci&SID but nothing shows in broswer window.

@mpsews:

sudo nano /path/to/file/removed/phpmyadmin/.htaccess

order allow,deny

Allow from All

is the content of my .htaccess file. but still phpmyadmin is not opening in browser window. When i open 212.71.255.110/phpmyadmin link this redirects me to https://212.71.255.110/phpmyadmin/?coll … ral_ci&SID">https://212.71.255.110/phpmyadmin/?collationconnection=utf8general_ci&SID but nothing shows in broswer window.

I think it should be deny, then allow. It should be deny from all, then allow from IP addresses. The webserver should not allow everyone into PHPmyAdmin.

@mpsews:

When i open 212.71.255.110/phpmyadmin link this redirects me to https://212.71.255.110/phpmyadmin/?coll … ral_ci&SID">https://212.71.255.110/phpmyadmin/?collationconnection=utf8general_ci&SID but nothing shows in broswer window.

Try adding /index.php. Looks like you may not have Indexes set up in your web server:

http://212.71.255.110/phpmyadmin/index.php

Best Regards,

Dave

You should remove the actual file paths from your posts. It's not an actual vulnerability, but it can lead to exploitation of vulnerabilities.