Re: Cannot remove MySQL completely

On Mon, 17 Jan 2022 15:03:46 +0100
Axel Schwenke <[email protected]> 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.