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`.
Go to Windows command prompt

```
Microsoft Windows [Version 10.0.10586]
(c) 2015 Microsoft Corporation. All rights reserved.

C:\Users\avinash>cd/

C:\>cd "Program Files\MySQL\MySQL Server 5.7\bin"

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -u xyzzzz -p 
Enter password: ***** ERROR 1045 (28000): Access denied for user 'xyzzzz'@'localhost' (using password: YES)

 C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -u xyzzzz -p 
Enter password:

```