How to unlock and lock MySQL users?

[kumkumsharma]

You can lock MySQL user from MySQL database and also unlock them.

You can only modify MySQL user with root privileges and that’s why it is must to have root access.

You can login to MySQL as a root use this command:

# mysql

Now you have to run below command to lock user:

ALTER USER 'db_user'@'localhost' ACCOUNT LOCK;

And you have to run below command to unlock user:

ALTER USER 'db_user'@'localhost' ACCOUNT UNLOCK;