On 16/01/2022 23.35, John Levine wrote:
> It appears that pinnerite <
pinn...@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";
swordfish would be there as plain text and not as a hash. You would need