Help! Client is unable to get into MySql

I'm tring to use a Client from Win98 to access our MySql running on Redhat 6.2. I've gone in and set up my username in, host id and db's in the MySql DB. However, when I log in, I get the message:

Host '' is not allowed to connect to this MySQL Server."

In HOST table, i've set the host to '%' (for logging in from any machine) and a username of 'jerryh'. I also have set up my username and password in the USER table. What gives?

If you didn't use GRANT, did you FLUSH PRIVILEGES after making the entries? or restart mysqld?

Yup, after posting the original message, i restared mysqld, and viola, it worked!

Am I to assume that anytime I make changes to the tables in the MySql DB, I need to restart or flush privileges?

Only when you make direct changes, yes.

You should check out using GRANT and REVOKE. Generally much safer and no need to flush.

thanks for the tip. I did buy a book; i suppose i should RTFM carefully...!