SELECT user, authentication_string FROM mysql.user returns a bad field

[John Adams]

Hi, folks,

I'm getting an unreasonable failure to authenticate. The username and password in the URL are correct--I've checked them multiple times. However, when I SELECT user, authentication_string FROM mysql.user , the user which will not authenticate doesn't show up in the user column.

Instead, the authentication_string value is left-justified, like so:


+------------------+------------------------------------------------------------------------+
| user | authentication_string |
+------------------+------------------------------------------------------------------------+
w.o_oaaA&MOREGIBBERISHTHATFILLSOUTTHELINE |
| mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |

etc.

Any thoughts on what's going on?

Thanks,

John A