MySQL › Introduction to MySQL Databases › Question #15416
MCQ Single Best Answer Easy

QWhich MySQL command is used to add a new user account with administrative privileges?

ID: #15416 Introduction to MySQL Databases 97 views
Question Info
#15416Q ID
EasyDifficulty
Introduction to MySQL DatabasesTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • A GRANT ALL PRIVILEGES ✔ ✖
  • B ADD USER ✔ ✖
  • C CREATE USER ✔ ✖
  • D INSERT USER ✔ ✖
Correct Answer: Option 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.

 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

Which MySQL command is used to modify the structure of a table? Which MySQL command is used to delete a database? Which of the following is a widely used relational database management system? What is the purpose of the GROUP BY clause in a MySQL query? Which MySQL statement is used to delete a table from a database? What is the purpose of the WHERE clause in a MySQL query? Which statement is used to create a new database in MySQL? What is the purpose of the HAVING clause in a MySQL query? Which MySQL function is used to calculate the total number of rows in a table? Which MySQL statement is used to insert data into a table?