The problem is I have made a second user account for my databases, every time I open the MySql monitor it doesn't prompt me for a username, it just assumes I want to log into the Root and asks for my Root password. It doesnt ask for a username or which username I want to log in under.
I assumed that when I opened the mysql monitor it should prompt me to enter something like:
mysql -u username -p
but it just goes directly to my root, no username questions.
This is just a localhost install of mysql on my PC.
Thanks for any help.