Which table lists the accounts and the databases for which the privileges are provided?

Solution (By Examveda Team)

This question asks about which table in MySQL stores information about the privileges (permissions) assigned to different accounts.

The answer is Option A: user.

Here's why:

* user table: This table holds information about the users (accounts) in a MySQL database. It includes details like the username, host, password, and most importantly, the permissions granted to that user.

* db table: This table contains information about the databases themselves.

* tables_priv and procs_priv: These tables are used to store privileges related to specific tables and stored procedures, respectively. They don't contain the primary information about user accounts.

In summary, the user table is where you'd find the connection between accounts and the databases they have access to, along with their associated privileges.