Re: Cannot remove MySQL completely

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

> 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

So you know that the hash for 'mythtv' looks OK. It just happens to be the wrong hash.
I could not change it to the correct one. 

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

Anyway it is arbritary as I deleted the database and started again.

Alan


-- 
Mint 20.3, kernel 5.4.0-95-generic, Cinnamon 5.2.7
running on an AMD Phenom II X4 Black edition processor with 16GB of DRAM.