Lab Hack: WP Site URL change MySQL using terminal
Log into MySQL
$ mysql -u root -p
Enter the password and to select the database
mysql> use wordpress;
mysql> show tables;
Next step is to update:
mysql> update wp_options set option_value = 'http://www.kewrunner.name' where option_id = 1;
Check to verify if changes were made:
mysql> select * from wp_options where option_value = 'https://www.kewrunner.name';
You’re done, and simply exit
mysql> \q
Remember to to disable any define('WP_HOME','http://domain.name'); define('WP_SITEURL','http://domain.name')