Login to MySQL from Command prompt

Here is the steps to start MySQL from command prompt in windows.

1. Click on start and go to programme.

2. Select MySQL and go for "MySQL command line client" under mysql <your mysql version>.

3. MySQL command prompt will be open asking you for password.

4. Enter the password.

5. Now you should see something like..

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 6 to server version: 5.0.24-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

6. Here you go. You are in MySQL command line console :)