content_image/851099.jpg
## The user and db Grant Tables 

SHOW GRANTS FOR ’bob’@’pc84.example.com’; 

To display nonprivilege properties of an account, use SHOW CREATE USER : 

SHOW CREATE USER ’bob’@’pc84.example.com’; 

The server uses the user  and db  tables in the mysql  database at both the first and second stages of access control (see Section 6.2, “Access Control and Account Management” ). The columns in the user and db  tables are shown here. 

<img src='content_image/851099.jpg'>

