Access phpmyadmin via lan using mom

Question

We are trying to configure the installation of Mamp Pro (on Mac), which allows us to access PhPmyAdmin on top of lan. We can access the htdocs folder to edit its contents using standard sharing, so this is not a problem.

The problem is that we cannot see PhPmyAdmin access to this installation. I searched Google several times trying to make this work, and now I'm trying here.

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

HTTP: // IP-ofserver: 8888 / MAMP

but this does not work, and I get this error:

Forbidden You do not have access to / MAMP access on this server.

Access to the very contents of the server is working. I get a test webpage with a clean installation of mamp pro.

Customization

Internet → Airport Extreme provides LAN

3 hosts are connected to Lan and one is a mini-mini with a lamp installed on it.

Answer 1

I did not find the right answer, but found a job, just copy the MAMP / bin / phpMyAdmin directory under MAMP / htdocs /

Rename the folder, in my case I have MAMP / htdocs / dba Then you just do: http: // (dev-machine-ip) / dba

Replace (dev-machine-ip) with the IP address of your development computer where MAMP is installed. The reason for changing the folder name is because httpd.conf has a configuration that redirects / phpMyAdmin to another physical folder. Of course, you can also just remove this directive, right down to you.

Answer 2

I was able to solve this problem with MAMP Pro by adding the local IP address to the http.conf file.

I conclude this by going to (from the MAMP Pro window) file > Edit Template > Apache > http.conf , scrolling to line 399, there was a block of text

  Alias /phpMyAdmin "/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin" Alias /phpmyadmin "/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin" <Directory "/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin"> Options Indexes AllowOverride None Order deny,allow Deny from all Allow from localhost Allow from 127.0.0.1 Allow from ::1 </Directory> 

and editing to allow my local IP address (which is 192.168.2.xxx)

  Alias /phpMyAdmin "/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin" Alias /phpmyadmin "/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin" <Directory "/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin"> Options Indexes AllowOverride None Order deny,allow Deny from all Allow from localhost Allow from 127.0.0.1 Allow from ::1 #Adding in new rule to allow local IPs to access, leave the last number blank to allow all in that range Allow from 192.168.2 </Directory> 

We rebooted the server and accessed phpmyadmin from another computer on our network by entering http://[HostComputerIP]:8888/phpMyAdmin

Answer 3

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

.htaccess files contain apache directives for the specific folder in which they are located, and all subfolders in this folder. These directives are the same that will normally live in the /etc/apache2/httpd.conf file, except that they are allocated to 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 force Apache to ignore all .htaccess files. 2. Create a section in /etc/apache2/httpd.conf using <Directory … > and move all directives from the abusive .htaccess to this section. Use <Directory> to indicate which directory the directives apply to. Then delete the .htaccess file. 3. If you can, move the .htaccess file in violation of the file structure to where it is really needed.

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