Confused about privileges

[Todd Cary]

I have created a table, "sfyc" and as root I issued the following:

grant all on * to todd identified by 'my_password' with grant option;

However, "todd" cannot access "sfyc" with

mysql -u todd -p sfyc

And the mysql db contains the following:

user table
+-----------+------+
| host      | user |
+-----------+------+
| %         | todd |
| linux     | root |
| localhost | root |
+-----------+------+

db table
+------+---------+------+
| host | db      | user |
+------+---------+------+
| %    | mysql   | todd |
| %    | test    |      |
| %    | test\_% |      |
+------+---------+------+

tables_priv;
+------+-------+------+------------+
| host | db    | user | table_name |
+------+-------+------+------------+
| %    | mysql | todd | localhost  |
+------+-------+------+------------+

If I issue the following command, no changes take place in the above tables:

grant all on sfyc to todd identified by 'my_password' with grant option;

Do I need to do an "insert SQL command" to specifically enter the 
information?

Todd

-- 
Ariste Software
200 D Street Ext
Petaluma, CA 94952
[phone]