Home » MCQs » MariaDB MCQs

Which of the following is the correct query to delete a password for a user named 'alex'?

21. Which of the following is the correct query to delete a password for a user named 'alex'?

1. SET PASSWORD FOR 'alex'@localhost = PASSWORD("");
2. SET PASSWORD FOR 'alex'@localhost = null;
3. DEL PASSWORD FOR 'alex'@localhost;
4. SET PASSWORD FOR 'alex'@localhost = PASSWORD("null");

Answer: A) SET PASSWORD FOR 'alex'@localhost = PASSWORD("");

Explanation:

The correct query to delete a password for a user named 'alex' is:

Syntax:

SET PASSWORD FOR 'alex'@localhost = PASSWORD("");