title: Logging in as a different user on MySQL
body: <p>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:</p>
  
  <p><a href="https://stackoverflow.com/questions/5689841/trouble-logging-into-mysql-as-non-root/5690053#comment-6499191">Trouble logging into mysql as non root</a></p>