mysql> insert into user (host,user,select_priv,insert_priv, update_priv,password) values ( "www.people.virginia.edu", "selectuser", "Y", "N"."N", ""); mysql> insert into user (host,user,select_priv,insert_priv, update_priv,password) values ( "node14.unix.virginia.edu", "selectuser", "Y", "N"."N", ""); mysql> grant select on test.* to selectuser; Query OK, 0 rows affected (0.00 sec)