mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

[username]- username of your database

[password]- password of your database

[databasename]- your database name

[backupfile.sql]- name of the file to which the backup should be written

if using MySql for the first time then we use the command

#mysqladmin -u root password 'yourpassword'

 give your own password for 'your password' but without quotes

if you know your root password and want to reset it. then we can use the command

 #mysqladmin -u root -p'oldpassword' password 'newpassword'

give your old password and new password but without quotes.

if you forgot the root password 

In this guide I will show how to use MySQL in Windows. This guide is  intended to help those who have very little knowlegde of using MySQL.