[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
Automatic Email Organization without missing anything!