Re: Cannot remove MySQL completely
Axel Schwenke <[email protected]> Mon, 17 Jan 2022 15:03:46 +0100
| Newsgroups | comp.databases.mysql |
|---|---|
| Organization | A noiseless patient Spider |
| Message-ID | <[email protected]> |
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"