Sign in to follow this  
Medulla_Oblongata

[web] Question about phpMyAdmin privileges

Recommended Posts

I set up phpMyAdmin, everything works fine and stuff... BUT, I want to deny root access outside my LAN. I know I can allow and deny access but I'm doing something wrong. Here is the priveleges table: User Host Password Global privileges Grant tempuser % Yes USAGE No root localhost Yes ALL PRIVILEGES Yes So... that means root can only have access on localhost... right? Then why can I log in from elsewhere? Or am I wrong? (tempuser has only access to 1 database and can log in from anywhere) edit: I found this peace of code on the phpMyAdmin site. It's supposed to block root from logging outside the private network, but somehow something goes wrong. I can't log in at all.
     //block root from logging in except from the private networks
    $cfg['Servers'][$i]['AllowDeny']['order'] = 'deny,allow';
    $cfg['Servers'][$i]['AllowDeny']['rules'] = array(
        'deny root from all',
        'allow root from localhost',
        'allow root from 10.0.0.0/8',
        'allow root from 192.168.0.0/16',
        'allow root from 172.16.0.0/12',
        );

[Edited by - Medulla_Oblongata on October 1, 2004 4:10:44 AM]

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this