u/DownFromHere

I'm running a local MySQL database through AdminNEO and made a terrible mistake of deleting "root" from the main user in the database host. So as far as I know it's now an empty string but command line won't accept and I can no longer access the database. I can't believe I made such a silly mistake. I've looked online and tried to look in the .sql file to identify the CREATE USER line but it's not in the file. Is there anyway I can recover or reset the database from the command line?

UPDATE: Solved with this https://localwp.com/help-docs/getting-started/how-to-import-a-wordpress-site-into-local/#export-a-site