Noticed that by default wordpress keeps the site name www.mysite.com/wordpress but we wanted to change it to www.mysite.com/blog. Based on the documentation and other stackoverflow posts, it's as simple as making following changes.
- override WP_SITEURL and WP_HOME in wp-config.php
- Fix .htaccess entries to have correct rewrite rules
- Update Permalinks settings
Or manually update wp_options table if you are unable to get into WP admin console.
Also followed all the steps mentioned here but still no luck, getting 404 errors when going to the new URL.