HowTo: Disallow access to phpMyAdmin for a specific user

[ProWebUK]

Simple guide to disallowing access to phpMyAdmin for a specific user:

# pico -w /var/www/html/phpmyadmin*VERSION*/config.inc.php

After one of the sections (eg mysql settings) add the section:


'OTHER SETTINGs'
);

//block user from logging into phpMyAdmin
$cfg['Servers'][$i]['AllowDeny']['order'] = 'deny,allow';
$cfg['Servers'][$i]['AllowDeny']['rules'] = array(
'deny *USER* from all',
);


// another section....


Replace the *user* with the username you wish to remove access from.

Chris

[S2S-Robert]

And if you'd like to enable logging in from only 1 ip (your own f.i.;)) you can set the allow rule as well.

Check out these two links that might be helpfull:

http://www.directadmin.com/forum/showthread.php?s=&threadid=1412
http://www.phpmyadmin.net/documentation/#config