How to use Mysql from command Prompt

To connect to Mysql from command Prompt you need to follow these simple steps

1.  First you should have Mysql Server installed in your system
2.  To connect to Mysql from cmd you have to set the class path
3.  Right click on computer->properties->Advance System settings->advanced->environment variables->System variables->path
4. Add the path of Mysql server till bin as follows
5. C:\program files\mysql\mysql server 5.1\bin
6.  Now you can connect to Mysql from command prompt
7.  Open cmd and type as follows
8. C:\Users\Personal>mysql -uroot –proot  and yes you are connected to Mysql