Re: Connect to db 3306 rights after 4yrs (Windows)
From: Axel Schwenke <axel.schwenke_at_gmx.de>
Date: Tue, 12 Mar 2019 11:20:11 +0100
Message-ID: <d1864fa9-a54d-5add-ae6e-e23558f7822e_at_gmx.de>
Date: Tue, 12 Mar 2019 11:20:11 +0100
Message-ID: <d1864fa9-a54d-5add-ae6e-e23558f7822e_at_gmx.de>
On 12.03.2019 00:59, vjp2.at_at_at.BioStrategist.dot.dot.com wrote:
> I haven't used MySql in a few years.
> I am preparing to input a new db (20 mln recs)
> I thought I had to manually delete the files
That is wrong. You must *never* delete any InnoDB files from the datadir manually.
> Goodenss, i can't remember the password if it somehow went away
> What do I do?
Since you already deleted some files, your data is damaged and possibly completely gone. So you can delete anything else from the MySQL datadir and try a fresh start. I suggest to install a more current version of MySQL and create a superuser account with a new password. Received on Tue Mar 12 2019 - 11:20:11 CET