NYCPHP Meetup

NYPHP.org

[nycphp-talk] phpMyAdmin 2.6.4-pl3 problem

Max Gribov max at neuropunks.org
Mon Oct 24 10:30:00 EDT 2005


Hello,
I am having an authentication issue with phpmyadmin 2.6.4-pl3.
The auth mechanism is set to 'cookie', but I cannot get any users to login.
I get

051024  9:19:53   31443 Connect pmacontrol at xxx.xxx.xxx.xxx on
31443 Query       SELECT VERSION() AS version
31444 Connect Access denied for user: 'user at xxx.xxx.xxx.xxx' (Using
password: YES)

in the log file.
MySQL stores all user passwords using its internal password('password')
function. Proper access lists are defined for both pmacontrol at ip and for
user at ip
I ran all GRANT statements from documentation.
pmacontrol user, as well as the user Im trying to use, are able to login
from the host with mysql -h db -u user -p command, I tested it, and I
can do select's on mysql database.

config.inc.php for phpmyadmin:

$cfg['PmaAbsoluteUri'] = 'https://mysql.xxx.com/';
$cfg['blowfish_secret'] = 'bw_password';
$cfg['Servers'][$i]['host']          = 'db';
$cfg['Servers'][$i]['controluser']   = 'pmacontroluser';
$cfg['Servers'][$i]['controlpass']   = 'password';
$cfg['Servers'][$i]['auth_type']     = 'cookie';
$cfg['Servers'][$i]['user']          = '';
$cfg['Servers'][$i]['password']      = '';
$cfg['Servers'][$i]['pmadb']         = 'phpmyadmin';

Everything else is default, database phpmyadmin exists (not really
relevant for this it seems), my browser works fine with cookies.
I followed all the instructions from documentation, did a bunch of flush
privileges; from mysql, but still nothing works.
Can anyone shed some light on this?

Thank you very much!
max




More information about the talk mailing list