The user Table

• Administrative privileges such as RELOAD and SHUTDOWN are specified only in the user table.
  • The reason for this is that administrative operations are operations on the server itself.
    • They are not database-specific.
    • There is no reason to list these privileges in the other grant tables.
    • To determine if an administrative operation can be performed, the server need consult only the user table.

• The FILE privilege also is specified only in the user table.
  • The ability to read or write files on the server host is independent of the database being accessed.

What are the privileges provided by MySQL?

---

---

© 2007 John Michael Pierobon

Notes