[root@host]:/home/paul# mysql -u root -p mysql
Enter password: 

mysql> show tables;
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv    |
| db              |
| func            |
| host            |
| tables_priv     |
| user            |
+-----------------+
6 rows in set (0.00 sec)



mysql> select * from user;
+------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User    | Password         | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| %    | root    | 29bb48b07ee5526b | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          |
| %    | paul    | 29bb48b07ee5526b | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          |
| %    | mrdepot | 05128d2c596c67b7 | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          |
+------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
3 rows in set (0.02 sec)


mysql> select * from db;
+-----------+---------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host      | Db      | User    | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+-----------+---------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| %         | paul    | paul    | Y           | Y           | Y           | Y           | Y           | Y         | Y          | Y               | Y          | Y          |
| localhost | mysql   | root    | Y           | Y           | Y           | Y           | Y           | Y         | Y          | Y               | Y          | Y          |
| %         | mrdepot | mrdepot | Y           | Y           | Y           | Y           | Y           | N         | N          | Y               | Y          | Y          |
+-----------+---------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
3 rows in set (0.00 sec)


mysql 3:
mysql> insert into user values ('localhost','paul',password('paul'),'N','N','N','N','N','N','N','N','N','N','N','N','N','N');
mysql> insert into db values ('localhost','paul','paul','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
mysql> FLUSH PRIVILEGES; 

mysql 5:
mysql> insert into user (Host,User,Password) values ('localhost','user',password('pass'));
mysql> insert into db values ('localhost','db','user','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');