[web] Question about phpMyAdmin privileges

Started by
0 comments, last by GameDev.net 19 years, 6 months ago
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]
Advertisement
Bump


[google] didn't find anything I need to know... not even phpMyAdmin's site [sad]

This topic is closed to new replies.

Advertisement