Re: Cannot remove MySQL completely

On 18.01.2022 17:40, pinnerite wrote:
> Axel Schwenke <[email protected]> wrote:
> 
>> Then let's take a step back. Something must have been broken so that you
>> started digging into MySQL accounts. What was it? Perhaps a broken (or at
>> least not up-to-date) mythtv package?
> 
> This is the User table prior to wiping out an starting again..
> +------------------+------------------------------------------------------------------------+-----------+
> | User             | authentication_string                                                  | Host      |
> +------------------+------------------------------------------------------------------------+-----------+
> | mythtv           | *B5BCD029F2268798922CDC55B5253D354B2C0246                              | %         |
> | debian-sys-maint | $A$005$F5%d'zoHMtJEX88t/x1bvIEMnwtseub5Tc7Z02gRpckab8.tZPnvPL5       | localhost |
> | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | localhost |
> | mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | localhost |
> | mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | localhost |
> !ug2Ym[S%/K+ca2n7M06VWGOgOzJFxxKkrg/c7pjNT6Dm3n3FzLXm56 | localhost |
> | root             | *2B2E29BFA4C432ED2C7C49E07B175220796B98EE                              | localhost |
> +------------------+------------------------------------------------------------------------+-----------+

I see nothing wrong here.

> Nothing I could do would change the erroneous hashed mythtv password nor could I remove the penultimate row with seemingly no user.

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.

<shrug>


XL