What is the order of privileges in MySQL?

In MySQL, there is a hierarchical system of privileges. The order is as follows:

  • Global
  • Host Level
  • Database Level
  • Table specific
  • Column specific

For each of these levels there is a separate grant table in the MySQL database.