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.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion