Question: What mysql statement is used to check which accounts have specific privileges?

  1. show grants (displays the privileges and roles that are assigned to a MySQL user account or role)
  2. show privileges (shows the list of system privileges that the MySQL server supports)
  3. show access
  4. show user permissions

Answer: The correct answer of the above question is Option A:show grants (displays the privileges and roles that are assigned to a MySQL user account or role)