Re: Weird password problem

[Micah Yoder <LYoder@cyberis.net>]

Dana:  RE: SQL monitor

I've never been able to run the MySQL monitor.  Can someone give me a
proper command line?  I just about got it once, but it never quite
worked.

but anyway, it does appear to be a MySQL problem, not PHP.

"Aaron D. Turner" wrote:

> I ran into this exact same problem with mod_perl authentication.  For some
> reason I'd always get this random extra character at the end.
> 
> I found the solution (excuse my SQL/perl notation)
> 
> $passwd = "SELECT PASSWORD($passwd_sent)";
> chop($passwd);
> 
> The chop gets rid of the extra character at the end so that you can
> properly verify.

Crap.  That is *NOT* cool.  This will have to be run for EVERY
authenticated Web page requested, and it will require another SELECT for
each one!

There needs to be a better way.  Perhaps someone should ask the MySQL
authors.  Would the new beta version fix this?  Is it a known bug?