mysql see user privileges on database code example

Example: mysql check user privileges

SHOW GRANTS FOR 'root'@'localhost';