Error: Access denied for user, Account is locked

mysql -u hr -p
Enter password: ************

ERROR 3118 (HY000): Access denied for user 'hr'@'localhost'. Account is locked.

Solution: Login with Root user and unlock the account.

--Check the Status of User is locked.
SELECT user, host, account_locked
 FROM mysql.user
 WHERE user = 'hr';

--Unlock the User account
ALTER USER 'hr'@'localhost' ACCOUNT UNLOCK;

Check the number of attempts for the locked accounts

SHOW GLOBAL STATUS LIKE 'Locked_connects';