Logon Question

This is probabaly a simple question, so I'll preface by saying I'm totally new to this. I installed MySQL 4.0 on my home PC and am working locally. I've figured out how to start and stop the server and the root logon. The book I'm going through had me create a new dbs, called testdb and then want me to create a user with access to testdb. This all went smoothly using:

Grant all on testdb.* to testuser identified by 'testpw';

When I try to logon with the userid and pw I can't get in when I use this syntax:

mysql>mysql -utestuser -ptestpw

However, if I use:

mysql>mysql -utestuser

it works fine. Note the id and pw I'm using are testuser and testpw. I went and logged in as the root user (no pw) and did the pw change command and it looked sucessfully.

So, the question is....why isn't it making me use the password?

Thanks in advance.
Willhh3

try:
mysql testdb -utestuser -p
Then it prompts for the password... simply enter the password.

Thanks a ton MadCow. That put me in the right direction as I started to get prompted for a pw. Of course then I kept getting access denied. I finally figured out that when I created the ID I needed to make it:

testuser@localhost rather than just testuser.

What puzzles me is the if I try to login with just:

mysql -utestuser

it lets me in with what looks like root permissions. If I do the show database command it only displays Test. Strange, but I think I'm getting the hang of it.

Thanks!
willhh3