WordPress

Adding of custom CSS/styles:

• Login to WP admin site.

• On the left side menu, go to Appearance > Customize.

• Click Additional CSS.

• Put all the CSS/styles in the input box then click Publish to apply your changes.

To change WordPress site URL:

• Note: This is also the fix when restoring a WordPress site to a new URL/domain.

• sudo mysql -u root -p

  • show databases;

    • Note: Remember the database you want to update.

  • use <database_name>;

    • E.g. use serbisyo;

  • show tables;

    • Note: Remember the table prefix of your tables.

  • SELECT * FROM <table_prefix>_options WHERE option_name = 'siteurl';

    • E.g. SELECT * FROM wp_options WHERE option_name = 'siteurl';

    • Note: Copy the option_value value of the query result.

  • UPDATE <table_prefix>_options SET option_value = '<new_url>' WHERE option_value = '<old_url/option_value_from_previous_query>';

    • E.g. UPDATE wp_options SET option_value = 'https://staging.serbisyo.com' WHERE option_value = 'https://www.serbisyo.com';

  • exit

    • To exit the mysql cli.