[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