Mysql access denied for user 'root'@'localhost' (using password yes).

Question

Problem :

I am naïve to mysql. Currently I am continuously facing below error.

“Mysql access denied for user 'root'@'localhost' (using password yes)”.

I have recently started using mySQL Workbench and after doing research on above error I found that my root's schema privileges are null. I do not have any privileges at all.

Because of above issue I am facing a lot of troubles across the platforms for which my server is used for and one more information want to share here is it is the sudden issue.

I have already tried some things for example FLUSH HOSTS, FLUSH PRIVILEGES, etc but it was of no us. I want to get my root access back as soon as possible. Can somebody help me in getting my root access back?

Answer 1

I had faced this issue in recent past. I had ubuntu 18 and I simply installed MySQL (password:root) with the help of below commands.

sudo apt install mysql-server
sudo mysql_secure_installation

I was able to login to MySQL very easily with the help of the super user. I used below commands and luckily I was able to log in with the help of normal user.

sudo mysql    
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
exit;

After above step I was able to login to my Mysql with a normal account.