How To Change WordPress URL using phpMyAdmin in DirectAdmin

Are you looking for an article on how to change WordPress URL using phpMyAdmin in DirectAdmin? Well, you are at the right place. In this article, we will explain how can you simple change WordPress URl using phpMyAdmin in directadmin.

Let’s get started!

Why Change Your WordPress URL?

Why do you need to change your WordPress URL? Scroll down to learn:

1. Moving to a New Domain: Well, maybe you have moved your blog and changed the domain, and what follows now is the process of getting WordPress to reflect that change.

2. Shifting from HTTP to HTTPS: Switching to HTTPS enhances your site's final protection, but the essence is shifting to the new URLs.

3. Correcting a Mistake: This might be a by-product of what a user does only once while installing or configuring URL components.

4. Site Migration: If you are moving from one domain to another or even if your site only requires a change of server or directory, then it is important to change the URL.

Preparing for the Change

Ensure to back up your database.To back up your database in DirectAdmin:

1. Log in to your DirectAdmin account.

2. Navigate to the “MySQL Management” section.

3. Find the database associated with your WordPress site and click on it.

4. Use the “Export” function to download a copy of your database.

Accessing phpMyAdmin in DirectAdmin

- Log In to DirectAdmin:

- Open your DirectAdmin control panel and log in with your credentials.

- Navigate to phpMyAdmin:

- Once logged in, look for the “phpMyAdmin” option. It’s usually found under the “Account Manager” or “Your Account” sections.

- Click on “phpMyAdmin” to open it.

- Select Your Database:

- In phpMyAdmin, you’ll see a list of databases on the left-hand side. Click on the database associated with your WordPress site. If you're unsure which one it is, you can usually find this information in your wp-config.php file located in your WordPress root directory.

Updating the WordPress URL in phpMyAdmin

Now that you’re in phpMyAdmin and have your database selected, you’re ready to update the WordPress URL.

1. Locate the wp_options Table:

- In the list of tables, find and click on wp_options. Depending on your database prefix, it might be named something like wp123_options.

2. Find the Site URL and Home Options:

- In the wp_options table, locate the rows with the option names siteurl and home. These two options control the URL settings for your WordPress site.

3. Edit the Site URL:

- Click on the “Edit” button (usually a pencil icon) next to the siteurl row.

- In the option_value field, enter your new URL. Make sure to include the full URL, including http:// or https://.

- Click on “Go” or “Save” to save your changes.

4. Edit the Home URL:

- Repeat the same steps for the home row. Click the “Edit” button, update the URL in the option_value field, and save your changes.

Double-Checking Your Work

After updating both the siteurl and home options, it’s essential to double-check that everything is set correctly.

1. Clear Your Browser Cache:

- Sometimes, browsers cache old versions of your site. Clear your browser cache to make sure you’re seeing the updated site.

2. Log in to Your WordPress Dashboard:

- Try accessing your WordPress dashboard with the new URL to ensure everything is functioning correctly. If you can log in and navigate the dashboard without issues, you’ve successfully updated your URL.

3. Check Your Site:

- Visit your new URL and browse through a few pages to make sure everything looks and works as expected.

Troubleshooting

Remain calm even if things don't look quite right. Here are some pointers for troubleshooting:

Verify for errors: Verify that the URLs you supplied in phpMyAdmin are correct.

Database backup: You can always restore your database from the backup you made previously if something goes wrong.

Update Permalinks: Occasionally, you may need to change your permalinks. To do so, click "Save Changes" after going to "Settings" > "Permalinks" in your WordPress dashboard.

Wrapping Up

To finally, change your WordPress URL using phpMyAdmin if you’re logged into DirectAdmin, you’ll find that it isn’t nearly as complex as you once thought. Here are some of the ways that can be followed systematically and in a planned way to make the change-over to a new URL less catastrophic; For your information, always backing up your database is very important in preventing an extensive loss of your site. 

By adopting the above guidelines, it is possible to update the WordPress URL with ease and without jeopardizing the website’s performance.