Access denied for user ‘root’@’localhost’ (using password yes) MySQL - EASY Fix

Edit you config file: /etc/mysql/my.cnf

Add the skip-grant-tables option under [mysqld]. It should look something like this:

[mysqld]
skip-grant-tables

Restart the MySQL service:

service mysql restart

Login as root. It shouldn’t require a password anymore.

mysql -u root

Start off by flushing privileges:

mysql> flush privileges;

Set a new password for the root user and flush privileges again:

Password=PASSWORD('my_password') where USER='root';
FLUSH PRIVILEGES;

Remove skip-grant-tables Option

Edit your config file again: /etc/mysql/my.cnf

This time just remove the skip-grant-tables option under [mysqld].

Restart the service:

service mysql restart

You should now be able to login using a password.