Logging in as a different user on MySQL

I created a different user, when I try to log into mysql it will not let me. I think I am missing a step. I am using windows 7. When I log in it automatically asks me for a password. If I enter the root password I can use mysql. If I enter the password I have created for the user, I get an error I cannot read and the program exits. Do I need to first login as root then somehow log in as new user. I am very confused. The code I used to create the new user is here:

Trouble logging into mysql as no开发者_开发百科n root

---

Try this:

>> mysql -u USERNAME -p 

Press enter, and you'll be prompted for the password for USERNAME.

---

There is no mysql equivalent to Oracle's 'connect' statement in the sense that allows to switch a user once already logged in to a mysql console session.

---

You may have created the new user, but not given that user sufficient permissions on the database you're trying to manage.