New to MySql - easy question about managing users 1

[iggystar]

Hi,
I'm about 3 days along in using MySql without docs and I have a problem. I've added a user and gave the user privledges to a database, but quite by accident I gave the user a password. At least I assume it's a password since it looke like a hashed string that appears next to his name on the user table.

My question is, how do I get rid of the password? Also if somebody could tell me how to remove a user I would appreciate that as well.

Finally, anybody have a link to some good MySql docs?

 

[iggystar]

REMOVE FROM user WHERE user = "name"

From the lack of responses I guess nobody knew how to do this so I figured I'd share now that I figured it out.