Database Reference
In-Depth Information
Figure 12.9
Mary's amended entry in tables_priv.
Table 12.1
The MySQL grant tables.
Table name
Uses
user
Stores the global privileges for the whole server (examined in Figure 12.1).
db
Stores the privileges for a specific database on the server (examined in Figure 12.10).
host
Stores database-specific privileges for the specified host.
tables_priv
Stores the privileges for access to a given table within a specific database (examined in
Figure 12.7).
columns_priv
Stores the privileges for access to a given column within a specific table within a database.
Figure 12.10
The db table.
Search WWH ::
Custom Search