There are 5 tables that store the privilege information for a MySQL environment, They are in the mysql database (USE mysql;)
user: Stores the Usernames and Passwords for all users
tables_priv: Stores the table privileges
procs_priv: Stores the privileges for accessing Stored Procedures and functions
db: Stores the privileges for the database
columns_priv: Stores the column privileges