Help with GRANT

Hello all, I'm new to MySql, so any and all help is appreciated.

I've installed mysql on my win2k box running IIS. I'm using winmysqladmin.exe and created a user and password for the my.ini file.

I am connecting with: c:\mysql\bin> mysql -u <user> -p

However when I try: mysql -h <hostname> -u <user> -p it does not connect and says that <user>@<host> is not allowed (PASSWORD=YES)

I've been reading the manual on GRANT and I've been typing this in:

grant all on . to <user>@"%";
the response is:
Query ok, 0 rows affected, <0.00 sec>

So basically it's telling me I have a query with no syntax errors but it's not really granting all privleges to my <user>.

Thanks again for all the help, and If I need to clarify something please point that out. Thank you.

Neil Park

Neil,

Worth trying logging on just by typing:

mysql

as I think that under W2K an entry is put in the user table for all users at the localhost.

If you can connect, then issue your grant statement. In MySql, After any changes to user, you need to force MySql to flush it's security definitions.

Command is: Flush privileges.

More info available at:

Cheers
Justin