Access phpmyadmin over lan using mamp

Question

Dear stackoverflow users and contributors,

We are trying to set up a Mamp Pro installation ( on Mac ) which allows us to access PhPmyAdmin over the lan. We can access the htdocs folder to edit it's contents using standard sharing so that is not a problem.

The problem is that we can't seem to the access the PhPmyAdmin of this installation. I've googled for several hours trying to make this work and now I'm trying here.

I found several cases where they explain that you can access your phpMyAdmin via this:

http://ip-ofserver:8888/MAMP

but this is not working and I get this error:

Forbidden You don't have permission to access /MAMP on this server.

Accessing the servers content itself is working. I'm getting the test webpage provided with the clean installation of mamp pro.

Setup

Internet -> Airport Extreme provides LAN

3 hosts are connected to the Lan and one is a mac mini with the Lamp installation on it.

Can somebody help please?

Thx in advance!

Answer 1

I had this problem and it turned out to be a .htaccess file installed for another application that was being applied to phpMyAdmin too.

.htaccess files hold apache directives for the specific folder where it lives and all sub folders within that folder. These directives are the same ones that normally would live in the /etc/apache2/httpd.conf file except for the fact that they are being singled out for a specific directory of web files.

Solutions: 1. Use BBedit to edit the /etc/apache2/httpd.conf file. Change "AllowOverride All" to "AllowOverride None". However, this will cause Apache to ignore all .htaccess files. 2. Create a section in /etc/apache2/httpd.conf using and move all the directives from the offending .htaccess to that section. Use to be specific which Directory the directives are applied to. Then erase the .htaccess file. 3. If you can, move the offending .htaccess file down the file structure to where it's actually needed.

Note that .htaccess is a hidden file on the Mac. Look up what tools are available to make hidden files visible so you can work on them, like BBedit and the Pref Pane Secrets.