see mysql user access code example

Example: mysql check user privileges

SHOW GRANTS FOR 'root'@'localhost';