Publicly allowing remote mysql and phpmyadmin

clever_j 2017-03-16 02:33:14 UTC #1

I just setup LAMP stack , Im on a Google Compute Engine

So far so good. but i wanted to know next steps to allow remote mysql connection as well as allow public access to phpmyadmin
Upon reading the docs , for phpmyadmin, it seems you need to setup tunneling and all that. but honestly i dont want to deal with that. I just want to allow it openly but, for security, bound to a few IP addresses that i own.

Can't seem to find it in the docs. Is this allowed? how do i do it (coming from a fresh install of LAMP full stack Bitnami->GCE)

ps
I'm not very good with server administration, i've been on managed hosting since forever. But i do catch on pretty quick. Just need a nudge in the right direction (and confirmation if this was possible before i spend time trying to hehe)

bulgaru 2017-03-16 21:57:44 UTC #2

If i were you, i would not open it up. Otherwise, the conf you need to edit is this one:
/opt/bitnami/apps/phpmyadmin/conf/httpd-app.conf

I'm not sure if it's the only thing that forbids access, but you should start there.

clever_j 2017-03-17 01:12:27 UTC #3

I understand the concern, thanks. but this will be during dev only , i plan to close it all up once i go into production.

Ill give that conf a try..

jota 2017-03-17 08:57:36 UTC #4

Hi @clever_j,

As @bulgaru mentioned, you will need to edit the httpd-app.conf file of phpMyAdmin to modify the Apache configuration for that application. In your case, you will need to edit the "Require local" line of this block

<IfVersion >= 2.3>
    Require local
</IfVersion>

to any of these options:

Require all granted : It grants access to everyone
Require ip XXX.XXX.XXX.XXX : It grants access to a single IP or IP range

You will find more information in the official documentation of Apache

https://httpd.apache.org/docs/2.4/howto/access.html

Please note that you will need to restart Apache after performing the changes:

https://docs.bitnami.com/google/infrastructure/lamp/#how-to-start-or-stop-the-services

Regards,
Jota

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!