How to Change the WordPress URL Using phpMyAdmin in cPanel

What is this about?

A URL is a web address, like https://example.com. WordPress stores its address in a database. A database is a filing cabinet for your site's data. phpMyAdmin is a tool that lets you open it. You reach it from cPanel, the control panel for your hosting.

You may need this after moving a site, adding SSL, or changing your domain name. Use it if the normal settings page does not load.

Warning: a wrong address can lock you out of your site. Take a backup of the database first. In phpMyAdmin, click Export and then Go.

Steps

1. Log in to your client area at https://secure.hostvento.com/clientarea.php.
2. Open cPanel for your hosting service.

   

3. In the Databases section, click phpMyAdmin.

   

4. On the left, click your WordPress database. Not sure which one? Look for DB_NAME in your wp-config.php file.

   

5. Click the table named wp_options. Your prefix may be different from wp_.
6. Find the row where option_name is siteurl. Rows are shown across several pages, so use the search box if needed.
7. Click Edit on that row.
8. In option_value, type the new address. Include https:// and leave off the last slash.
9. Click Go.
10. Do the same for the row where option_name is home.

    

11. Open your new address in the browser and test.

Another way: wp-config.php

You can also add two lines to the wp-config.php file. Use File Manager in cPanel. Add them above the line that says to stop editing:

define( 'WP_HOME', 'https://example.com' );
define( 'WP_SITEURL', 'https://example.com' );

These lines override the database values. Replace example.com with your own domain.

Quick recap

• Back up the database first.
• Edit siteurl and home in the wp_options table.
• Use the full address with https://.
• Test your site afterwards.