Change WordPress URL or Home in MYSQL

Occasionally, your WordPress site will not load it's dashboard because the database is trying to connect to the wrong url.

This can happen if you have moved a database from one site to another or your having an SSL related issue.

You can change the WordPress url manually by logging into your phpMyAdmin tool at https://mysql.webhero.com or https://myql56.webhero.com.

Once you have logged in, click on Databases at the top of the page then select your DB.

Select the wp_options table on the left side of the page (your db may have a different prefix other than wp_) then click Edit to change either or both the siteurl or home.