By Charles Joseph | Cybersecurity Researcher
Published on
December 26th, 2023
Table of Contents show
The WordPress table that houses your site’s URL is wp_options, where wp_ is your database table prefix.
The wp_options table schema has 4 columns:
Stay One Step Ahead of Cyber Threats
Want to Be the Smartest Guy in the Room? Get the Latest Cybersecurity News and Insights.
- option_id
- option_name
- option_value
- autoload
Two rows in this table maintain your site’s URL. These are locatable from the values specified in “option_name,” — siteurl, and home.
The SQL command to change these values in MySQL:
Site URL
mysql> UPDATE wp_options SET option_value = ‘https://your-domain.com’ WHERE option_name = ‘siteurl’
Home
mysql> UPDATE wp_options SET option_value = ‘https://your-domain.com’ WHERE option_name = ‘home’
SOURCE: How do I change the WordPress Site URL?
QUOTE:
"Amateurs hack systems, professionals hack people."
-- Bruce Schneier, a renown computer security professional
"Amateurs hack systems, professionals hack people."
-- Bruce Schneier, a renown computer security professional
