mysql look at privileges of users code example

Example: mysql check user privileges

SHOW GRANTS FOR 'root'@'localhost';