While redesigning a website, I normally use a temporary URL for example, pilot.laksha.net and when ready to launch, I change the website URL to the real URL. During this process, I have caught in middle where I changed the Site Address (URL) setting in the WordPress from pilot to real URL but that URL is still not fully working.
The issue in this case is, WordPress will redirect any attempt to open the page to new URL and you have no way to access the setting page to change. Fortunately there is a simple solution available to override WordPress Site Address (URL) values that is saved in database.
In this method, you will have to open wp-config.php file which can be found in the root of your WordPress install. Make sure you make a back up copy of this file before you open it. If you are using shared hosting, then please use control panel provided by hosting company or use FTP application such as FileZilla.
Open the wp-config.php file and add following lines to this config file where the “http://example.com/” is the URL you want to access.
define( 'WP_SITEURL', 'http://example.com/' );
define( 'WP_HOME', 'http://example.com/' );