how to connect to mysql database from command line in windows

 I am using XAMPP software for programming and MySQL as a Database.

Go command line

C:\>d:

d:\>cd xampp\mysql\bin

d:\xampp\mysql\bin> mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 47
Server version: 5.6.24 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| 007                |
| 02                 |
| assignment         |
| bidar              |
| cdcol              |
| cr_debug           |
| crm                |
| demo               |
 || mydb               |
| mysql              |
| om                 |
| orthos             |
| performance_schema |
| phpmyadmin         |
| prabha             |
| signup             |
| test               |
| webauth            |
+--------------------+
23 rows in set (0.00 sec)