Re: User with erroneous password

It appears that pinnerite  <[email protected]> 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, [email protected], Primary Perpetrator of "The Internet for Dummies",
Please consider the environment before reading this e-mail. https://jl.ly