MySQL: View Permissions

  • Replace {user} with the name of the user.

View Available Privileges

SHOW PRIVILEGES;

View Permissions

SHOW GRANTS FOR '{user}'@'%';