Recently, I changed my mysql
root user to someother username (say
kevin). But, now both the accounts don't login with the old password. It says
I'm also not sure if the username is that (
kevin). How can I retrieve both the root username and password?
I also tried resetting my mysql root password but I cannot, it says
Access denied. Even if I use the root username, it logs in but I cannot see any database like
mysql (Clearly, I don't have any privilege). Just the two basic databases are accessible. I am using Ubuntu 13.10, if that helps.
PS - I cannot reinstall mysql as I have important data stored in the databases.