Re: Weird password problem

["Dana M. Diederich" <dana@realms.org>]

mysql -h <host of mysql server> -u <mysql user> -p <table name>
And then enter the password.

Cheers.
-Dana
-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,
Dana M. Diederich        Phone: 1.501.855.7175
SMTP: dana@realms.org    HTTP:  http://realms.org/dana/   ICQ: 16433785
Snail Mail: 19 Leicester Drive, Bella Vista, Ar 72714, USA
`Berkeley invented LSD and Unix, and I don't think that's a coincidence.'
> 
> 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?
>