title: Login in MySQL as a different user from command prompt
body: <p>I already created the new user and given it ALL PRIVILEGES. But as soon as I open command prompt I am given to enter the password for my user (which I did't set) I hit enter and it lets me into MySql as a root user. When I exit that, it closes the command prompt and when I opet it again, it automatically says enter the password ( for the root user). How can I switch to the user that I just created? Thanks</p>