Data Dictionary MySQL Tutorial

MySQL server uses a database 'mysql' to store the permission.
MySQL permissions work on a hierarchy of
Host
User
Databases
Tables
Columns