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 figured out solution. There is system command, where we can execute shell command like 'ls, cd, mv, mkdir etc.. Here we can login as different user. first I logged in as regular user.

```
[madegow@fedora20 ~]$ mysql -u root -p
Enter password: 
...
MariaDB [(none)]> select user()
-> ;
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

MariaDB [(none)]> system mysql -u madegow -p
Enter password: 
...
MariaDB [(none)]> select user();
+-------------------+
| user()            |
+-------------------+
| madegow@localhost|

```

Now user got changed to madegow user.
but when you run quit/exit it will not go back to root. we need to bare with that.
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`.