Question: What mysql statement is used to check which accounts have specific privileges?
- show grants (displays the privileges and roles that are assigned to a MySQL user account or role)
- show privileges (shows the list of system privileges that the MySQL server supports)
- show access
- 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)