From Newsgroup: comp.databases.mysql

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.
--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.databases.mysql

It appears that pinnerite <pinnerite@gmail.com> said:

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

UPDATE user set authentication_string="swordfish" where user="mythtv";

I also want to remove the penultimate line which appears to have no user(?)

DELETE from user where authentication_string like "ug2Ym%";

If that doesn't work, see if you can figure out what crud is really in the user string, e.g.

SELECT hex(User), authentication_string, Host from user;
--
Regards,
John Levine, johnl@taugh.com, Primary Perpetrator of "The Internet for Dummies",
Please consider the environment before reading this e-mail. https://jl.ly
--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.databases.mysql


On 16/01/2022 23.35, John Levine wrote:

It appears that pinnerite <pinnerite@gmail.com> said:

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

UPDATE user set authentication_string="swordfish" where user="mythtv";

Not sure that would work well, as far as I'm aware it would lead to that swordfish would be there as plain text and not as a hash. You would need
to use PASSWORD('swordfish').

I think the following is more what you "should" do:

SET PASSWORD FOR 'mythtv'@'%' = bigshark;

sure you can also use later user in the same way too.
--

//Aho
--- Synchronet 3.21d-Linux NewsLink 1.2