mysql登陆其他用户出错,在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:

解决方案

Try this:

>> mysql -u USERNAME -p

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