Home » MCQs » MariaDB MCQs

Which is the correct MariaDB query to lock an existing user?

48. Which is the correct MariaDB query to lock an existing user?

1. CREATE USER 'alex'@'localhost' ACCOUNT LOCK;
2. ALTER USER 'alex'@'localhost' ACCOUNT LOCK;
3. ALTER USER 'alex'@'localhost' LOCK;
4. ALTER USER LOCK 'alex'@'localhost';

Answer: B) ALTER USER 'alex'@'localhost' ACCOUNT LOCK;

Explanation:

The correct MariaDB query to lock an existing user is:

Syntax:

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