I accidently removed root user from mysqld:
DROP USER 'root'@'localhost'; Query OK, 0 rows affected (0.00 sec)
Now I am unable to do anything (as expected), but I would like to understand the recovery steps. How to continue now, or am I doomed?
I've even followed the steps from another thread (I believe I've deleted MySQL root user, how do I recreate it?), but it doesn't work either
Basically I would like to know how to start afresh, if possible