ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

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

Answer & Solution
Correct Answer: Option A
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.