Q: Which MySQL command is used to add a new user account with administrative privileges?
-
A
GRANT ALL PRIVILEGES
-
B
ADD USER
-
C
CREATE USER
-
D
INSERT USER
C
Answer:
C
Explanation:
The CREATE USER command is used in MySQL to create a new user account. It allows you to specify the username, password, and privileges for the user. Administrative privileges can be granted separately using the GRANT statement.
Related Topic:
Share Above MCQ