//It is possible to set the site URL manually in the wp-config.php file.
//Add these two lines to your wp-config.php, where “example.com” is the correct location of your site.
define( 'WP_HOME', 'http://example.com' );
define( 'WP_SITEURL', 'http://example.com' );
//Important! Do not leave this code in the functions.php file. Remove them after the site is up and running again.
update_option( 'siteurl', 'http://example.com' );
update_option( 'home', 'http://example.com' );
options table
1. siteurl
2. home
######## OR ########
// Add to top of wp-config.php
define( 'WP_HOME', 'http://example.com' );
define( 'WP_SITEURL', 'http://example.com' );
<?php
update_option( 'siteurl', 'http://example.com' );
update_option( 'home', 'http://example.com' );
/*
This is the safer way to do it.
Upload this file to your active theme directory.
Use your own URL instead of example.com, obviously.
Refresh in http://example.com/wp-login.php after adding/updating functions.php
Remove the lines or the remove the file after the site is up and running again.
more information here: https://wordpress.org/support/article/changing-the-site-url/#edit-functions-php
*/
update_option( 'siteurl', 'http://example.com' );
update_option( 'home', 'http://example.com' );