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.
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

```