HELP - Lost Mysql Root Account!
mysql server was compromised on one of my servers. the hacker DELETED the root user from mysql and changed all the passwords of other users.now i was able to restart the mysql server the --skip-grant-tables so the server can be accessed without a password. however since the root user was deleted (not just the password, the entire account) how can i restore root access? obviously grant command doesnt work with --skip-grant-tables so even if i was able to reset all the passwords i could not regain the root privilege.
please help!! thanks.