Re: Cannot remove MySQL completely

On Tue, 18 Jan 2022 15:26:18 +0100
Axel Schwenke <[email protected]> wrote:

> On 18.01.2022 13:48, pinnerite wrote:
> > 
> > I appreciate you taking the trouble to reply in detail but you must understand thast I am not a regular user of MySQL and have only ever used it when employing MythTV.
> 
> 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?
> 
> That's the whole point of having packages and maintainers. But of course
> they need to know something is broken before they can act.

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 |
+------------------+------------------------------------------------------------------------+-----------+

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

It is history now. I had a couple of weird problems with this version of Linux Mint. 
One was solved with a fix.
The other, well that is MythTV but I will get there.

Regards, 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.