Groups | Search | Server Info | Login | Register
Groups > comp.databases.mysql > #7623
| Path | csiph.com!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | pinnerite <pinnerite@gmail.com> |
| 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> (permalink) |
| 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) |
| Xref | csiph.com comp.databases.mysql:7623 |
Show key headers only | View raw
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.
Back to comp.databases.mysql | Previous | Next — Next in thread | Find similar
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