If you need to change the URL for a WordPress blog, and only have access via MySQL, you can use the following command, once you have selected the database. Keep in mind I am assuming the wp_ table prefix.
UPDATE wp_options SET option_value='http://www.example.com/' WHERE option_name='siteurl' or option_name='home';
Leave a Reply