Jump to content
  • Advertisement
Sign in to follow this  
Medulla_Oblongata

[web] Question about phpMyAdmin privileges

This topic is 5032 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

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
Sign in to follow this  

  • Advertisement
×

Important Information

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

We are the game development community.

Whether you are an indie, hobbyist, AAA developer, or just trying to learn, GameDev.net is the place for you to learn, share, and connect with the games industry. Learn more About Us or sign up!

Sign me up!