Tag Archives: wordpress database url

How to change a WordPress URL using phpMyAdmin

This guide will show you how to manually change a WordPress URL by using phpMyAdmin & cPanel to update your domain or WordPress installation path.

Sometimes it may be necessary to manually change the URL for your WordPress site directly in the database. For example, if you have the main domain on your cPanel account changed to a different domain & have a WordPress website installed, the domain name would be changed on the cPanel account but not in the database.

Quick steps:

  • Login to cPanel
  • Navigate to the File Manager option
  • View the wp-config.php file in the document root and make a note of the database name.
  • Navigate to phpMyAdmin option in cPanel and expand the database name we have noted.
  • Locate the wp_options table and look for entries, option_name: siteurl & option_name: home
  • Click the edit option on the left for each entry and enter your new domain URL
  • Click Go at the bottom to save the changes

The first thing to do is locate the wp-config.php file in order to determine what the database name is that is being used for the WordPress site in question. To do this, navigate to the File Manager in cPanel as shown below.

cpanel-main-menu-file-manager

cpanel-main-menu-file-manager

 

By default, the file manager should open in the “home” directory. Double-click in order to navigate into the public_html directory, which is where your publicly accessible files would be located.

 

cpanel-file-manager

cpanel-file-manager

 

Once you’ve entered into the public_html directory, you should see your WordPress files. Note, if you have WordPress installed in another directory such as “wp” or “blog” etc, you will need to navigate into that folder.

Locate the “wp-config.php” file. Now, right-click on the file & click “view”.

 

cpanel-file-manager-right-click

cpanel-file-manager-right-click

 

After clicking “view” as shown above, the wp-config.php file should be opened in another tab in your browser. From here scroll down to the section titled “The name of the database for WordPress”.

 

wp-config.php

wp-config.php

 

As shown above, we now know that the database name is “veerotechdemo_w209” – this entry will be different from yours, but the format will be similar.

The next step is to locate the database in phpMyAdmin via cPanel. Navigate back to cPanel & locate the icon for phpMyAdmin.

 

cpanel-main-menu-phpmyadmin

cpanel-main-menu-phpmyadmin

 

After clicking the phpMyAdmin icon, this will open phpMyAdmin in another tab in your browser. From here, you’ll need to locate the database name that we previously identified from viewing the wp-config.php file. If you have multiple databases, you’ll need to be sure you’re choosing the one specifically noted in the wp-config.php file in the previous steps in this guide. You’ll then want to click the + symbol to expand the tables.

 

phpmyadmin-main-menu

phpmyadmin-main-menu

 

After clicking the + symbol to expand the tables for the database, locate the wp_options table. Note – the first prefix for your database may not be wp_ so be sure to look for the second half of the prefix which would be _options

Once you have located the _options table, click the table to show the entries. Look for two entries that you’ll need to modify.

– option_name: siteurl
– option_name: home

 

phpmyadmin-browse

phpmyadmin-browse

 

Once you have located the URL entries to change click the edit option on the left for each entry to enter your new domain. When entering your new URL into the field, be sure to still include the http:// or https:// portion for your domain. Once you’ve entered the new domain in the proper format, click Go at the bottom.

 

phpmyadmin-main-edit

phpmyadmin-edit

 

After clicking Go to save the changes, you’ll be taken back to the previous page where you can do the same for the second entry, the home URL. For this one, follow the same steps as above to ensure both entries listed match. You’ll see in the screenshot below that both of our entries match for the siteurl and home entry.

Note: This is important because if these do not match, the site will not load properly.

 

phpmyadmin-files

phpmyadmin-files

After you have changed both URL’s to the new URL you would like to use (which must be associated with the hosting account), your site should now load properly. You may need to clear any caching plugins or browser caches as well. Should you have any issues or questions, feel free to reach out to our support department.

Conclusion:

Congratulations! You have learned how to manually change a WordPress URL using phpMyAdmin.