Path: csiph.com!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: pinnerite <pinnerite@gmail.com>
Newsgroups: comp.databases.mysql
Subject: Re: Cannot remove MySQL completely
Date: Mon, 17 Jan 2022 16:57:50 +0000
Organization: A noiseless patient Spider
Lines: 33
Message-ID: <20220117165750.f8dc48ba66e8fc7513db85f0@gmail.com>
References: <20220117114805.c031fa47fced17cde62197b8@gmail.com> <4789f309-afb4-6231-cadc-2d1a524eee3a@gmx.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: reader02.eternal-september.org; posting-host="9b942ee64b20248ef55fb07904152181"; logging-data="5014"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18aEvHIT61s/ODNRaHpjgNR+CihmXn3t+k="
Cancel-Lock: sha1:PqXY7PJvB1uq7Db9Q35FK/SteME=
X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.32; x86_64-pc-linux-gnu)
Xref: csiph.com comp.databases.mysql:7630

On Mon, 17 Jan 2022 15:03:46 +0100
Axel Schwenke <axel.schwenke@gmx.de> wrote:

> On 17.01.2022 12:48, pinnerite wrote:
> > Recent posts have culminated in my not being able to remedy a corruption in the user table.
> > 
> > I decided to remove MySQL and reinstall.
> 
> This is not Windows. Your cannot solve problems by reinstalling software. Or
> rebooting your computer.
> 
> > When I reinstalled, the corrupt user table was still there.
> 
> Because the data directory is not auto-removed. This is for safety. A fresh
> datadir is only created if none exists.
> 
> Now: what "corruption" do you have in the `user` table? Keep in mind that
> you should not operate on the user table with UPDATE and DELETE statements.
> There are dedicated CREATE user and DROP user statements. Read the manual on
> "Access Control and Account Management"

Thank you. Slightly too late - this time. I have completely restored MySQL.
The corupt data is gone. 

At the moment I can only get int MySQL from a root prompt. 

Otherwise it asks for the root password which I have not set(?).



-- 
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.