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 = '' where option_id = 1;

Check to verify if changes were made:

mysql> select * from wp_options where option_value = '';

You’re done, and simply exit

mysql> \q

Remember to to disable any define('WP_HOME',''); define('WP_SITEURL','')


Inventory Script

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