Re: lost mysql root password

["Matt Price" <moptop99@gmail.com>]

>
> do:
>
> select hex(User) from user where User LIKE 'root%';
>
>
> that should give you the hex values of the characters that are there.
>
> >
> > have all four.  I guess there must be some white space in the username
> > somewhere.  Is there an easy way to identify the precise value of a
> > mysql field (e.g. by dumping to a CSV file)? I'd like to try to figure


+----------------------------------+
| hex(User)                        |
+----------------------------------+
| 726F6F74                         |
| 726F6F74202020202020202020202020 |
| 726F6F74                         |
| 726F6F74202020202020202020202020 |
+----------------------------------+
4 rows in set (0.00 sec)

thanks anoop!  I guess those 02's are spaces then...  Looks like most
of the user lines from my old db are corrupted in this way as well. 
wierd.
Thanks much for your help!

matt