phpMyAdmin

Discussion in 'Installation/Configuration' started by mhasan, Jul 21, 2011.

  1. mhasan

    mhasan New Member

    I'm new to both ISPConfig 3 & phpMyAdmin. I want deny root user for phpMyAdmin. To do so I have added following line to /etc/phpmyadmin/config.inc.php

    Code:
    $cfg['Servers'][$i]['AllowRoot'] = FALSE;
    But I'm still able to login as root user. Please someone tell me what I'm missing.

    Thanks in advance.
     
    mhasan, Jul 21, 2011
    #1
  2. erosbk

    erosbk New Member

    I am using Debian, what distro do you use? I don't know if conf files of pma are or not case sensitive, but I have it working for me with this line in /etc/phpmyadmin/config.inc.php

    $cfg['Servers'][$i]['AllowRoot'] = false;

    Modify it and next try to reload/restart apache2.
     
    erosbk, Jul 21, 2011
    #2
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    Make sure that you closed your browser one after you edited that config. Othewise the old phpmyadmin configuration might be still cached in the session. Beside that, make sure that you added that line at the correct place in the config file, so that it applies to the config instance that connects to localhost.
     
    till, Jul 21, 2011
    #3
  4. CSsab

    CSsab New Member

    Allow root access to phpmyadmin from local networks only

    I added these to my phpmyadmin config:

    // Allow root access from local networks only
    $cfg['Servers'][$i]['AllowDeny']['order'] = 'deny,allow';
    $cfg['Servers'][$i]['AllowDeny']['rules'] = array(
    'deny root from all',
    'allow root from localhost',
    'allow root from 192.168.1.0/24',
    );

    Change the red to suit your local network
     
    CSsab, Jul 22, 2011
    #4
  5. mhasan

    mhasan New Member

    I'll try & let you know guys. Thanks a lot.
     
    mhasan, Jul 22, 2011
    #5

Share This Page