Knowledge Base
MilesWeb / How-Tos

How To Change WordPress URL using phpMyAdmin in cPanel

Approx. read time : 3 min

This guide explains how to manually change a WordPress URL using phpMyAdmin and cPanel that can update your domain or WordPress installation path.

Sometimes, there can be a need to manually change the URL for your WordPress site directly in the database. For example: if your domain name on the cPanel account gets changed to a different domain and you have a WordPress installed, then the domain name gets changed on the cPanel but not in the database. So, in such cases, you can manually change the WordPress URL by performing the following steps.

1) First of all, find out the database name that is being used for the WordPress site whose URL needs to be changed. For this, locate the wp-config.php file, and navigate to the File Manager in cPanel.

cPanel File Manager

2) By default, the File Manager opens in the “home” directory. Double-click on it and navigate to the public_html directory. In this directory, your publicly accessible files are located.

cPanel public_html

3) After entering into the public_html directory, you will see all your WordPress files. Remember, in case you have installed WordPress in another directory like “wp”, “blog”, etc. you will have to navigate into that folder.

Navigate to “wp-config.php” file and right-click on the file and then click “view”.

cPanel WordPress file

4) Once you click on view, the wp-config.php file should get open in another tab in your browser. Now, scroll down till you find the section named as /* The name of the database for WordPress*\ line.

cPanel WP config

You can see the database name is “mileswebdemo_w209”. In your case, this entry will be different from the same format.

5) Now, you will have to locate a database in phpMyAdmin via cPanel. So, go back to cPanel and click on phpMyAdmin.

cPanel phpMyAdmin

6) You can see, phpMyAdmin will be opened in another tab on your browser. Now, you will have to locate the database name that has been previously identified from viewing the wp-config.php file. In case you have multiple databases, make sure that you are choosing the one that is specifically noted in the wp-config.php file in the previous step. Now click on + sign to expand the tables.

cPanel tables

7) Once tables get expanded, locate the wp_options table. Remember, the prefix of your database doesn’t need to be wp_ so just look for the second of the prefix which would be _options.

After locating the _options table, click on the table to display the entries. Identify 2 entries that you want to modify:

– option_name: siteurl

 – option_name: home

cPanel option value

In option value section we can see our URL as :

https://www.mileswebdemo.com/wordpress

https://www.mileswebdemo.com/wordpress

Similarly, you should see your site’s URL.

Once the URL entries are located, click on the edit option on the left side of each entry to enter a new domain. While entering your new URL in this file, remember to include the http://or https:// portion of your domain. After entering the new domain in a proper format, click on the Go button.

cPanel new domain

8) After clicking on Go, you will be redirected back to the previous page where you can perform the same activities for the 2nd entry, the home URL. Make sure that both entries listed to match. For example for MilesWeb the entries should be :

https://www.mileswebdemo.com/wordpress

https://www.mileswebdemo.com/wordpress

If these two don’t match, the site will not get load properly.

9) After changing both URLs to the new URL your site will load properly. You will have to clear some caching plugins or browser caches as well. In case you have any issues reach out to our support helpline.

That’s it!

Also Read :

1) Learn to stage a WordPress website using Softaculous in cPanel

2) How to configure WordPress Permalink Structure?

3) A Complete Guide to Customization of WordPress Fonts

Sonam Wagh
With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.
Need help? We’re always here for you.