Setup MySQL on Ubuntu Droplet getting error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Installed mysql - 5.7. I Had the same issue.

Tried the below steps:

1. dpkg --get-selections | grep mysql (to get the version of mysql).

2. dpkg-reconfigure mysql-server-5.7

3. mysql -u root -p

Without -p that doesn’t prompt you to ask password. Once you are in, you can create a user with a password by following steps :

CREATE USER ‘-your_name-’@‘your-hostname’ IDENTIFIED BY ‘your-password’;

GRANT ALL PRIVILEGES ON . to ‘-your_name-’@‘your-hostname’ WITH GRANT OPTION;

Exit from the root and login from the you gave above.

mysql -u -p

For some reason still just typing mysql does not work. AT ALL. Please let me know if this works, else I have other steps.

Use the right password.

I used mysql -u root -p and enter password and got working.