Results 1 to 10 of 10

Thread: [SOLVED] how to set phpmyadmin to listen only local

  1. #1
    Join Date
    May 2007
    Location
    sLOVEnia
    Beans
    223
    Distro
    Kubuntu 8.04 Hardy Heron

    [SOLVED] how to set phpmyadmin to listen only local

    Hello. I have phpmyadmin installed, but its globally available.
    I want to set it up so it will only appear in local network.

    Few years ago i solved this by make a subdomain and point it to 192.168.2.1 and i made a virtualhost on that domain which pointed to phpmyadmin.

  2. #2
    Join Date
    Aug 2008
    Location
    Lisbon, Portugal
    Beans
    101
    Distro
    Ubuntu 8.04 Hardy Heron

    Re: how to set phpmyadmin to listen only local

    Well, I'm not sure if there is any option in phpmyadmin to make it behavior like that.

    Although it might look like a weird solution, you could edit the PHP code in phpmyadmin to reject any access from non local IP addresses.

  3. #3
    Join Date
    Apr 2008
    Location
    UK
    Beans
    1,098

    Re: how to set phpmyadmin to listen only local

    Quote Originally Posted by qstraza View Post
    Hello. I have phpmyadmin installed, but its globally available.
    I want to set it up so it will only appear in local network.
    http://wiki.contribs.org/Phpmyadminmulti
    Brian.

  4. #4
    Join Date
    May 2007
    Location
    sLOVEnia
    Beans
    223
    Distro
    Kubuntu 8.04 Hardy Heron

    Re: how to set phpmyadmin to listen only local

    Code:
    To limit access to local network :
    
    db configuration setprop phpmyadminmulti access private
    signal-event console-save
    this is not working, what is the "db" command?

  5. #5
    Join Date
    Apr 2008
    Location
    UK
    Beans
    1,098

    Re: how to set phpmyadmin to listen only local

    Quote Originally Posted by qstraza View Post

    this is not working, what is the "db" command?
    Let's move on; that link doesn't appear particularly useful. Is

    http://www.factsandpeople.com/facts-...-to-phpmyadmin

    any better?
    Brian.

  6. #6
    Join Date
    Mar 2008
    Location
    Canada
    Beans
    239
    Distro
    Ubuntu 10.04 Lucid Lynx

    Re: [SOLVED] how to set phpmyadmin to listen only local

    What I did was to add this directive to /etc/apache2/httpd.conf

    Code:
    <Directory /usr/share/phpmyadmin>
    Allow from 192.168.0.0/24
    Deny from all
    </Directory>

  7. #7
    Join Date
    Mar 2006
    Location
    Williams Lake
    Beans
    Hidden!
    Distro
    Ubuntu Development Release

    Re: [SOLVED] how to set phpmyadmin to listen only local

    @alecz20 adding info to an old solved thread, isn't going to help many people, as most users will look at the post date, even though it is marked solved, and pass it by. With a 6 month release cycle, Ubuntu has changed quite a bit since the release of hardy (April, 2008), many solutions that worked then, don't work now.

  8. #8
    Join Date
    Feb 2005
    Location
    EU
    Beans
    549
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: [SOLVED] how to set phpmyadmin to listen only local

    Still a thread with a valid (and useful!) answer is better than a SOLVED without a useable Response

  9. #9
    Join Date
    Mar 2008
    Location
    Canada
    Beans
    239
    Distro
    Ubuntu 10.04 Lucid Lynx

    Re: [SOLVED] how to set phpmyadmin to listen only local

    @cariboo907

    I get your point, however, I was very unsatisfied with all the solutions provided.

    I often look at many solved threads, and the solutions are not relevant anymore.

    In my case, I believe (as mtron was also saying) that this solution is applicable to any system that uses apache with phpmyadmin, regardless of OS version.

    Plus it's elegant, and can be used in other similar circumstances.

  10. #10
    Join Date
    Feb 2005
    Location
    Texas
    Beans
    Hidden!
    Distro
    Ubuntu 10.10 Maverick Meerkat

    Re: [SOLVED] how to set phpmyadmin to listen only local

    FWIW, I completely agree with cariboo907 in that digging up old threads is usually in poor taste.

    On the other hand, alecz20's solution is (IMO) the simplest / best and it's baffling that it was not mentioned earlier in the thread. (I guess it's possible someone could be using nginx instead of Apache web server, but if they can't figure out how to restrict access at the IP level, I suspect they're working from a phpMyAdmin + Apache howto anyway...)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •