mysql statement to check which accounts have specific privileges code example

SHOW GRANTS FOR 'root'@'localhost';