Change the WordPress siteurl & home URL using MySQL command line

changing-the-wordpress-site-url.sql

/* When moving sites from one location to another, it is sometimes necessary to manually modify data in the database to make the new site URL information to be recognized properly. Many tools exist to assist with this, but generally I use this method */
-- Login to MySQL
use database;
show tables;
SELECT *
    -> FROM `wp_options`
    -> LIMIT 0 , 30;
update wp_options set option_value = 'http://example.com OR http://Server_IP' where option_id = 1; -- Most important to pick correct option_id for change "siteurl" option_value
update wp_options set option_value = 'http://example.com OR http://Server_IP' where option_id = 1; -- Use this command again to change "home" option_value
EXIT