How do I give a MySQL user a password?

[budbiss]

I am very VERY new to MySQL...I was following a tutorial which explains how to create users...I did what it said to create a user and password, but for some reason it didn't accept the password. Now when I login with this user, it doesn't require a password. How do I go back and try to add a password to this user again?

[Steveo31]

Here's what PHPmyAdmin came back with:

GRANT USAGE ON * . * TO "testUser"@ "localhost"IDENTIFIED BY "**********"WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;

And

SET PASSWORD FOR "testUser"@ "localhost" = PASSWORD( "******" ) 

...was used to change it. I believe PHPmyAdmin makes them stars for security, but the DB recognizes it. The first password is "dilbert101" and the second 874458.

[budbiss]

Thanks, but let me just verify something...

If I want to create a user, I log into root and run the GRANT command? Then I create the password with the 'SET PASSWORD' command?