Tim Legg schreef:
> My output is similar to this (Thanks to grc.com password generator).
>
> +------------------+-----------+-------------------------------------------+
> | User | Host | Password |
> +------------------+-----------+-------------------------------------------+
> | root | localhost | *4883CCF9DC8AAC41CBE1576EE7C30ECFFDB1EE23 |
> | debian-sys-maint | localhost | 2qcvaMBnP8qwm5Ik |
> | legg | localhost | *FA5726D8387429018CC8BE7FACBC43F1E51D5C2F |
> +------------------+-----------+-------------------------------------------+
>
> I see the password in plain text while the others are in a hash of some sort. That is probably where the problem is, and now I need to find a solution.
>> You can change the password with command
>>
>> mysql> update mysql.user set
>> password=PASSWORD('new-password')
>> where User =
>> 'debian-sys-maint' ;
>> mysql> flush privileges;
Reset the password with the method mentioned above. You probably set the
password not putting it in the PASSWORD('password') brackets. The
PASSWORD() command converts the plaintext password to a hash MySQL uses.
Good luck.
Sjoerd
Attachment:
signature.asc
Description: OpenPGP digital signature