How to Change WordPress Site URL Via phpMyAdmin ?

WordPress is a free and powerful open-source content management system (CMS) using which websites can be created for free. It is coming as a script in Softaculous given by Silicon House in linux reseller hosting. In this article, you will learn about changing wordpress site URL via phpMyAdmin.

In wordpress you can see there are 2 URLs.

The “Site Address (URL)” setting is the address you want people to type in their browser to reach your WordPress blog.
The “WordPress Address (URL)” setting is the address where your WordPress core files reside.

To change the wordpress site URL, you can follow the below procedure :

1. Login to cPanel of the website
2. Access to “PhpMyAdmin” under Databases
3. Expand the database associated with the WordPress installation and select the “wp_options” table
4. Search for “siteurl” within the “option_name” column and click the “Edit” link on the same row
5. Change the domain name within the “option_value” section
6. Click the “Go” button when done
7. You will be redirected to the wp_options table where the new domain will now be listed
8. Navigate through the pages and search for “home” within the “option_name” column and click the “Edit” link on the same row
9. Change the domain name within the “option_value” section and Click the “Go” button when done to change the URL.
10. Once done, you should now be able to access WordPress using the new domain name