Back to knowledgebase Knowledgebase

Update WordPress Home and Site URL in the Database

WordPress stores the site address in the database. If the wrong address is saved there, the site may redirect incorrectly or fail to load properly.

You can update the WordPress home and site URL from phpMyAdmin.

Before editing the database, take a backup if possible.

To update the URLs:

  1. Log in to the 4UHosting client area at https://clients.4uhosting.co.uk.
  2. Choose My Services.
  3. Find the hosting service and select Manage.
  4. Select Login to cPanel from the left side.
  5. Open phpMyAdmin.
  6. Select the database used by the WordPress site.
  7. Open the table ending in _options.
  8. Find the row named siteurl and edit the value.
  9. Find the row named home and edit the value.
  10. Save the changes.

The two values are often the same, such as https://example.co.uk.

The table prefix may not always be wp_, so the options table may have a different name, such as abc_options.

If you are not sure which database the site uses, check the wp-config.php file for the database name before making changes.