How do I change my wordpress URL back to its old settings

Go to your MySQL Command Line Client

Enter password that you used when you set up wordpress.

You will see a mysql> prompt.

Select wordpress database by typing “use wordpress” or whatever wordpress database name you used.

mysql> UPDATE wp_options SET option_value = replace(option_value, ‘http://the_url_that_messed_you_up’, ‘http://the_old_url_you_want_to_revert_back_to’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

If you are successful, you should see the following:

Query OK, 2 rows affected (0.02 sec)
Rows matched: 2  Changed: 2  Warnings: 0