NYCPHP Meetup

[Russ Demarest]

I had a similar problem. The mysql client was not the same version as  
the server. I upgraded and the problem went away.

Good Luck,
On Oct 24, 2005, at 10:30 AM, Max Gribov wrote:

> 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
>
> _______________________________________________
> New York PHP Talk Mailing List
> AMP Technology
> Supporting Apache, MySQL and PHP
> http://lists.nyphp.org/mailman/listinfo/talk
> http://www.nyphp.org
>
>