Locked Account

Issue Type

Housekeeping

Problem

Accounts can be locked to prevent use. This might be done for a number of reasons but it's always a good idea to check to see if they need to be removed or unlocked.

There are some reserved accounts which are locked by default and are excluded from the check.

Remediation

Unlock

You can unlock an account by running the following command:

ALTER USER [account] ACCOUNT UNLOCK;

Remove

You can remove an account by running the following command:

DROP USER [account];

External Resources

• MySQL ALTER USER
• MySQL DROP USER
• MySQL Reserved Accounts