Solution:
1- Make sure Database wp_option links are set
/* MySQL: */
update wp_options set option_value = 'http://example.com' where option_name = 'siteurl';
update wp_options set option_value = 'http://example.com' where option_name = 'home';
2- Additionally define url in wp-config.php file
define('WP_HOME','http://example.com');
define('WP_SITEURL','http://example.com');
3- Clear cache of from server
4- Clear your browser cache & history (Hurray!!! it solved my issue no redirection)
On Chrome, Navigate to chrome://settings/clearBrowserData and clear image and file cache.