Re: Cannot remove MySQL completely

On 20.01.2022 13:44, pinnerite wrote:
> On Wed, 19 Jan 2022 17:43:45 +0100
> Axel Schwenke <[email protected]> wrote:

>> I see no row with no user. I see garbled output for whatever reason. What
>> reports SHOW GRANTS ? And the hash for the 'mythtv' user looks ok. And it
>> would be a trifle so set it to something else with CHANGE PASSWORD ...
>>
>> So you are basically complaining about *nothing*. Or - to be more precise -
>> about things that you don't understand and believe to be erroneous.
> 
> So you know that the hash for 'mythtv' looks OK. It just happens to be the wrong hash.

One can (of course) not see that. That's the reason why the password is
hashed in the first place. But even if you lost the original password in
clear text - it's just that. Not an error in stored MySQL credentials.

> I could not change it to the correct one. 

Because you didn't try it the correct way. RTFM on CHANGE PASSWORD!

> So what is the user for: > > !ug2Ym[S%/K+ca2n7M06VWGOgOzJFxxKkrg/c7pjNT6Dm3n3FzLXm56 | localhost |  ?

That is garbled output. It's missing not only a complete field (the
username) but also the table decorations that the client puts around the
data fields. Probably due to unprintable characters.

And again. You are doing the wrong thing.

You should not go and SELECT from the mysql.user table directly (at least
not when you cannot interpret what you get back). Instead you should use
SHOW GRANTS. And yes, RTFM on that too.


XL