Jump to content
  • Advertisement
Sign in to follow this  

[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',
        'allow root from',
        'allow root from',

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

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.

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!