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: 
I was looking for an equivalence of the `CONNECT` command of Oracle Database and just found it with the command `\CONNECT` available on MySQL Shell (since version 5.7.12), but that's another story.

So, as said years ago by our friend [Shivakumara](https://stackoverflow.com/users/5079503/shivakumara-k-madegowda), the answer is:

```
MySQL> SYSTEM mysql -u user -p

```

Which is nothing but calling an OS shell command from MySQL prompt.
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:

```