Jump to content
  • Advertisement
Sign in to follow this  
Guest Medulla_Oblongata

[web] Question about phpMyAdmin privileges

This topic is 5398 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

Guest Medulla_Oblongata
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
Advertisement
Guest Medulla_Oblongata
Bump


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

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

GameDev.net is your game development community. Create an account for your GameDev Portfolio and participate in the largest developer community in the games industry.

Sign me up!