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