Question: what is the windows command to switch to users on MySQL 
Im having a little problem in using mysql on windows. I know how to create a new user and giving grants to the new user and all. But i don't know how to switch to new user from mysql console!

Answer: 
The MySQL CLI session is bound to the user which started it. Thus, you'll have to open a new session with the desired user after you've created it and set needed grants. You can open a new session and keep the current one. Or, you can end the current session and then start new a one:

```
mysql -uUSER -p DATABASE

```

where `USER` is name of new user and `DATABASE` is database to switch to when you log on (`-p` points that you'll prompted to enter password). To exit the session, just use `exit`.
Creating user syntax : <http://dev.mysql.com/doc/refman/5.1/en/create-user.html>

Code : 

```
CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';

```

To switch the only way in command line is : 

```
mysql -u user -p

```