• User with erroneous password

    From pinnerite@21:1/5 to All on Sun Jan 16 22:13:52 2022
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From John Levine@21:1/5 to pinnerite@gmail.com on Sun Jan 16 22:35:21 2022
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From J.O. Aho@21:1/5 to John Levine on Mon Jan 17 07:48:55 2022
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)