How to open in MySql through Command prompt in windows system

Mysql is a Database and it is open source( free for all), Generally Mysql is on linux machine but you can also install & access Mysql in windows system.
MySQL is a popular choice of database for use in web applications, syntax of Mysql and Mssql is little bit different but nows a days use of Mysql is more because it is free.

For windows system you have to install mysql in your machine, once it install successfully the open CMD in your system. before this you have to start he mysql services in your system or if you have Wamp server in your system then you have to start the wamp server

C:\> 
Go to location where mysql is install Eg : C:\wamp\bin\mysql\mysql5.5.24\bin>
C:\> cd wamp\bin\mysql\mysql5.5.24\bin
C:\wamp\bin\mysql\mysql5.5.24\bin>
Enter the below Command in cmd then press enter key
mysql -u root -p

In above u stands for username and p stands for password, in my machine i have root user that I enter root you can enter other username also

C:\wamp\bin\mysql\mysql5.5.24\bin> mysql -u root -p

after if you write show Databases; command then it show you all database restore in the machine or list of database

mysql> SHOW DATABASES;

If you want to exit for the mysql then you have to write below command
mysql> exit