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')

RELATED POST

Inventory Script

Use this one all the time, it relies mostly on dmidecode output and keeps it very nicely organized for a…