Re: User with erroneous password

Path	csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	"J.O. Aho" <user@example.net>
Newsgroups	comp.databases.mysql
Subject	Re: User with erroneous password
Date	Mon, 17 Jan 2022 07:48:55 +0100
Lines	37
Message-ID	<j4khqoF7ud3U1@mid.individual.net> (permalink)
References	<20220116221352.dbd79933af0befced448a39c@gmail.com> <ss26j9$j5m$1@gal.iecc.com>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding	7bit
X-Trace	individual.net /rGoBXGuvlKQgr9vydGzfwISJGkWVCnRep+VYnzoXpWUmkG5t1
Cancel-Lock	sha1:1OriZO1b2wmIae5i7jU8T6zi+Z4=
User-Agent	Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.4.1
Content-Language	en-US-large
In-Reply-To	<ss26j9$j5m$1@gal.iecc.com>
Xref	csiph.com comp.databases.mysql:7625

Show key headers only | View raw

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

Back to comp.databases.mysql | Previous | Next — Previous in thread | Find similar

Thread

User with erroneous password pinnerite <pinnerite@gmail.com> - 2022-01-16 22:13 +0000
  Re: User with erroneous password John Levine <johnl@taugh.com> - 2022-01-16 22:35 +0000
    Re: User with erroneous password "J.O. Aho" <user@example.net> - 2022-01-17 07:48 +0100

csiph-web