Path: csiph.com!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: pinnerite <pinnerite@gmail.com>
Newsgroups: comp.databases.mysql
Subject: User with erroneous password
Date: Sun, 16 Jan 2022 22:13:52 +0000
Organization: A noiseless patient Spider
Lines: 29
Message-ID: <20220116221352.dbd79933af0befced448a39c@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: reader02.eternal-september.org; posting-host="6ca530beb6e11c04bccfbf3ecfdf11fb"; logging-data="5138"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX19luQQ0RKn899G3yQcGizVphQIA++EqHKM="
Cancel-Lock: sha1:5GVPYwLwYbP+Ixw6yVDepvPw14I=
X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.32; x86_64-pc-linux-gnu)
Xref: csiph.com comp.databases.mysql:7623

This is for a MythTV database.

$ sudo mysql --defaults-file=/etc/mysql/debian.cnf mysql

mysql> SELECT User,authentication_string,Host from user;
+------------------+------------------------------------------------------------------------+-----------+
| 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 want to change the authentication string in the first line with 'mythtv'.
I also want to remove the penultimate line which appears to have no user(?)
This in MySQL version 8.0.
Nothing I do succeeds.
Can someone put me straight?
TIA



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