Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  How-Tos  >  How To Change WordPress URL using phpMyAdmin in cPanel
Top Scroll

How To Change WordPress URL using phpMyAdmin in cPanel

 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 :

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 :

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 :

Learn to stage a WordPress website using Softaculous in cPanel

How to configure WordPress Permalink Structure?

A Complete Guide to Customization of WordPress Fonts

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
Claim the discount before it’s too late. Use the coupon code:
Note: Copy the coupon code and apply it on checkout.