Fix WordPress Site URL

Posted on by

You change the site url in WordPress and then cannot get the site to load at all. Revert it in the database.

1
2
3
4
5
6
7
8
9
10
11
12
mysql -u *YOURDBUSERNAME* -p
> *YOURPASSWORD*

show databases;

use *DBNAME*;

SELECT * FROM wp_options WHERE option_name="siteurl";
SELECT * FROM wp_options WHERE option_name="home";

UPDATE wp_options SET option_value="http://*YOURDOMAINNAME**" WHERE option_name="home";
UPDATE wp_options SET option_value="http://*YOURDOMAINNAME**" WHERE option_name="siteurl";

Leave a Reply