Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

"The Computer made me do it."

devel / comp.databases.mysql / Re: User with erroneous password

SubjectAuthor
* User with erroneous passwordpinnerite
`* Re: User with erroneous passwordJohn Levine
 `- Re: User with erroneous passwordJ.O. Aho

1
User with erroneous password

<20220116221352.dbd79933af0befced448a39c@gmail.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=68&group=comp.databases.mysql#68

  copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: pinnerite@gmail.com (pinnerite)
Newsgroups: comp.databases.mysql
Subject: User with erroneous password
Date: Sun, 16 Jan 2022 22:13:52 +0000
Organization: A noiseless patient Spider
Lines: 29
Message-ID: <20220116221352.dbd79933af0befced448a39c@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: reader02.eternal-september.org; posting-host="6ca530beb6e11c04bccfbf3ecfdf11fb";
logging-data="5138"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19luQQ0RKn899G3yQcGizVphQIA++EqHKM="
Cancel-Lock: sha1:5GVPYwLwYbP+Ixw6yVDepvPw14I=
X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.32; x86_64-pc-linux-gnu)
 by: pinnerite - Sun, 16 Jan 2022 22:13 UTC

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.

Re: User with erroneous password

<ss26j9$j5m$1@gal.iecc.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=69&group=comp.databases.mysql#69

  copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!news.iecc.com!.POSTED.news.iecc.com!not-for-mail
From: johnl@taugh.com (John Levine)
Newsgroups: comp.databases.mysql
Subject: Re: User with erroneous password
Date: Sun, 16 Jan 2022 22:35:21 -0000 (UTC)
Organization: Taughannock Networks
Message-ID: <ss26j9$j5m$1@gal.iecc.com>
References: <20220116221352.dbd79933af0befced448a39c@gmail.com>
Injection-Date: Sun, 16 Jan 2022 22:35:21 -0000 (UTC)
Injection-Info: gal.iecc.com; posting-host="news.iecc.com:2001:470:1f07:1126:0:676f:7373:6970";
logging-data="19638"; mail-complaints-to="abuse@iecc.com"
In-Reply-To: <20220116221352.dbd79933af0befced448a39c@gmail.com>
Cleverness: some
X-Newsreader: trn 4.0-test77 (Sep 1, 2010)
Originator: johnl@iecc.com (John Levine)
 by: John Levine - Sun, 16 Jan 2022 22:35 UTC

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

Re: User with erroneous password

<j4khqoF7ud3U1@mid.individual.net>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=70&group=comp.databases.mysql#70

  copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: user@example.net (J.O. Aho)
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>
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>
 by: J.O. Aho - Mon, 17 Jan 2022 06:48 UTC

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

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor