Connecting wordpress with localhost

Setting up a wordpress on localhost to do the work offline is not difficult but for those who are starting up with web development can be pretty iritating. So the task is to install and set up the wamp or xamp server and then install and implement wordpress on your localhost. Make an adequate changes in wp_config_sample.php file in order to connect it properly. Connect the wordpress with mysql. Solution is attached on chalenge