Re: Accidentally delete 'root' account

[Tanveer Malik]

Hi Peter,
Thanks for your response, I have tried everything you have suggested BUT unfortunately it had not worked for me.

I do have a normal user BUT with no Privileges and that's not able to see all the databases either, when I try to give that user any Privilege, I get an error .. Update Command denied to user ..

I have another version of MySQL database in WAMP [clean Install], If I can get the databases migrated to this new location even that will be helpful.

I have been trying to get out of this mess since about 11A my time and now it's quarter past one .. and still struggling.

Note: I am on a Windows 10 Computer, Using WAMP for my local Development - have no access as an Admin to any of the databases on that instance.

I AM USING MYSQL V8.0.28

Any help will be much appreciated!