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

```