Examveda

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

A. user

B. db

C. tables_priv

D. procs_priv

Answer: Option A

Solution (By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous