Vidyalelo
MySQL · Q237

MySQL

Programming · MySQL · question 237

Q237

The grant table that stores users who can connect to the server and their global privileges are . . . . . . . .

A.
user
Answer
B.
db
C.
tables_priv
D.
procs_priv

Answer: Option A

Solution

Answer: Option A
Solution:
This question is asking about where MySQL stores information about who can connect to the server and what they're allowed to do.

Here's a breakdown of the options:
Option A: user
This is the correct answer! The user table stores information about each user, including their username, password, and any global privileges they have.

Option B: db
This table stores information about databases, not users.
Option C: tables_priv
This table stores information about privileges granted to specific users on specific tables within a database.
Option D: procs_priv
This table stores information about privileges granted to specific users on stored procedures within a database.

In summary, the user table is where MySQL stores information about users and their global privileges.