Groups | Search | Server Info | Login | Register
Groups > comp.databases.mysql > #7639
| From | pinnerite <pinnerite@gmail.com> |
|---|---|
| Newsgroups | comp.databases.mysql |
| Subject | Re: Cannot remove MySQL completely |
| Date | 2022-01-20 12:44 +0000 |
| Organization | A noiseless patient Spider |
| Message-ID | <20220120124430.52c6e27199274bc0e5c712cf@gmail.com> (permalink) |
| References | (3 earlier) <340e9e53-3beb-1f86-531c-27904f871ed1@gmx.de> <20220118124859.8f1c20b86f5722837b1a9d5f@gmail.com> <ss6imb$pn1$1@dont-email.me> <20220118164016.fa5d28bbfaff06ad6db1179c@gmail.com> <ss9f42$ss2$1@dont-email.me> |
On Wed, 19 Jan 2022 17:43:45 +0100 Axel Schwenke <axel.schwenke@gmx.de> wrote: > On 18.01.2022 17:40, pinnerite wrote: > > Axel Schwenke <axel.schwenke@gmx.de> 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.
Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar
Cannot remove MySQL completely pinnerite <pinnerite@gmail.com> - 2022-01-17 11:48 +0000
Re: Cannot remove MySQL completely Bit Twister <BitTwister@mouse-potato.com> - 2022-01-17 06:26 -0600
Re: Cannot remove MySQL completely The Natural Philosopher <tnp@invalid.invalid> - 2022-01-17 13:22 +0000
Re: Cannot remove MySQL completely Axel Schwenke <axel.schwenke@gmx.de> - 2022-01-17 15:03 +0100
Re: Cannot remove MySQL completely pinnerite <pinnerite@gmail.com> - 2022-01-17 16:57 +0000
Re: Cannot remove MySQL completely Axel Schwenke <axel.schwenke@gmx.de> - 2022-01-18 10:44 +0100
Re: Cannot remove MySQL completely pinnerite <pinnerite@gmail.com> - 2022-01-18 12:48 +0000
Re: Cannot remove MySQL completely Axel Schwenke <axel.schwenke@gmx.de> - 2022-01-18 15:26 +0100
Re: Cannot remove MySQL completely pinnerite <pinnerite@gmail.com> - 2022-01-18 16:40 +0000
Re: Cannot remove MySQL completely Axel Schwenke <axel.schwenke@gmx.de> - 2022-01-19 17:43 +0100
Re: Cannot remove MySQL completely pinnerite <pinnerite@gmail.com> - 2022-01-20 12:44 +0000
Re: Cannot remove MySQL completely Axel Schwenke <axel.schwenke@gmx.de> - 2022-01-20 16:50 +0100
Re: Cannot remove MySQL completely Jerry Stuckle <jstucklex@attglobal.net> - 2022-01-18 15:49 -0500
Re: Cannot remove MySQL completely Dr Eberhard Lisse <nospam@lisse.NA> - 2022-01-19 12:29 +0200
Re: Cannot remove MySQL completely Jerry Stuckle <jstucklex@attglobal.net> - 2022-01-19 17:15 -0500
Re: Cannot remove MySQL completely Dr Eberhard Lisse <nospam@lisse.NA> - 2022-01-20 15:30 +0200
Re: Cannot remove MySQL completely Jerry Stuckle <jstucklex@attglobal.net> - 2022-01-20 13:06 -0500
csiph-web