wordpress address url accidentally changed code example

Example 1: wordpress address url accidentally changed

USE wp_database_name
UPDATE wp_options SET option_value="new_value" WHERE option_name="siteurl";
UPDATE wp_options SET option_value="new_value" WHERE option_name="home";

Example 2: wordpress address url accidentally changed

// wp-content/theme_name/functions.php

update_option( 'siteurl', 'new_value' );
update_option( 'home', 'new_value' );

// wp-config.php

define( 'WP_HOME', 'new_value' );
define( 'WP_SITEURL', 'new_value' );