MAMP Access phpMyAdmin Remotely

[djab]

Does anyone know of a way for people to access phpMyAdmin from MAMP remotely through a browser? This would be very helpful. Thanks!

 

[angelwatt]

Should work by default. Check the httpd.conf file for confirmation. You'll be looking for the part with,

<Directory "/Applications/MAMP/bin/phpMyAdminForPHP5">

One thing to watch out for though is that there's no default password (if I remember correctly) so anyone can go in and add/delete tables and database.

 

[djab]

Here is what i have in the httpd.conf file

It seems as if it lets people access it....hmmm😕 but it wont let me for some reason from another computer...

Alias /phpMyAdminForPHP5 "/Applications/MAMP/bin/phpMyAdminForPHP5"

<Directory "/Applications/MAMP/bin/phpMyAdminForPHP5">
    Options Indexes MultiViews
    AllowOverride None
    Order allow,deny
    Allow from all
</Directory>

 

[djab]

Nevermind got it working....how can i do it so they have to log in with the user name, password and database name to access their data?

Thanks

 

[angelwatt]

From what I remember you can setup accounts from within phpMyAdmin.

As far as accessing from other machines, is only that directory inaccessible? Also, are these other computers on your network, or from completely other locations?

 

[djab]

From what I remember you can setup accounts from within phpMyAdmin.

How does this work? Does it display a feild for database name, username, and password? and only lets the user access that or how does this work? How is this configured?

As far as accessing from other machines, is only that directory inaccessible? Also, are these other computers on your network, or from completely other locations?

What do you mean? Not understanding this question...

 

[angelwatt]

How does this work? Does it display a feild for database name, username, and password? and only lets the user access that or how does this work? How is this configured?

Looks like it was only adjusting permissions for users. To add users, you can do it from Terminal and login into MySQL directly.

What do you mean? Not understanding this question...

I mean can users access other parts of the web site, such as the home page or each others pages? And are these people on your network or people outside your network?

 

[a55mnky]

I am having the same problem

Nevermind got it working....how can i do it so they have to log in with the user name, password and database name to access their data?

Thanks

Did it occur to you that others might have the same issue and just saying oooh I figured it out isn't a very constructive contribution

May I ask how you figured it out