How to Reset/Recovery Web admin access? in EVE-NG

For community Edition
LOGIN AS ROOT USER IN CLI USING SECURE CRT
COPY AND PASTE AFTER LOGIN
===================================================
echo "DELETE from users where username = 'admin';" | mysql --host=localhost --user=root --password=eve-ng eve_ng_db
==============================================
echo "INSERT INTO users VALUES ('admin',NULL,'root@localhost',-1,'Eve-NG Administrator','85262adf74518bbb70c7cb94cd6159d91669e5a81edf1efebd543eadbda9fa2b',NULL,'','admin','',1);" | mysql --host=localhost --user=root --password=eve-ng eve_ng_db
===================================================
PROFESSIONAL EDITION 2.0.4-77 and below
echo "DELETE from users where username = 'admin';" | mysql --host=localhost --user=root --password=eve-ng eve_ng_db
====================================================
echo "INSERT INTO users VALUES ('admin',NULL,'root@localhost',-1,'Eve-NG Administrator','85262adf74518bbb70c7cb94cd6159d91669e5a81edf1efebd543eadbda9fa2b',NULL,'','admin','',0,-1);" | mysql --host=localhost --user=root --password=eve-ng eve_ng_db
======================================================PROFESSIONAL EDITION (2.0.4-97 and higher)
echo "DELETE from users where username = 'admin';" | mysql --host=localhost --user=root --password=eve-ng eve_ng_db
======================================================
echo "INSERT INTO users VALUES ('admin',NULL,'root@localhost',-1,'Eve-NG Administrator','85262adf74518bbb70c7cb94cd6159d91669e5a81edf1efebd543eadbda9fa2b',NULL,'','admin','',0,-1,'internal');" | mysql --host=localhost --user=root --password=eve-ng eve_ng_db
======================================================
#EVENGWEBACESS #EVE_NG

[@Metaloriginal]

Parabéns, muito obrigado somente esse tutorial resolveu meu problema!

[@GRODT_TWH]

Thanks, it helped me out. Travis

[@brunohenriquedeoliveiracar1452]

Muito obrigado! Me ajudou bastante!

[@daoudjanyaqubi3564]

root@eve-ng:~# echo "DELETE from users where username = 'admin';" | mysql --host=localhost --user=root --password=eve-ng eve_ng_db
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[@mh63111]

I got the same

[@daoudjanyaqubi3564]

For me not worked
I removed windows 8.1 and did a clean installation of windows 10 on my macbook pro and then install VMware 16 and re configured eve_ng from zero and finally worked

[@fandulan]

it is not working, saying insecure in command line

[@46gobin]

Not working Why ??