How to Change Your WordPress URL Using phpMyAdmin in DirectAdmin

When you ne­ed to update your WordPress site­'s URL or shift it to a different domain, using phpMyAdmin in the DirectAdmin is he­lpful. This guide provides a simplified proce­ss for safely making this adjustment.

Access DirectAdmin

1. Log in to your DirectAdmin control panel.

2. Navigate to the User Level or Admin Level, depending on your access rights.

Access phpMyAdmin

1. In the DirectAdmin dashboard, locate the MySQL Management option under the Your Account or Extra Features section.

2. Click on phpMyAdmin to open the database management interface.

            You might be prompted to log in again. Use your MySQL database username and password.

Select the WordPress Database

1. In phpMyAdmin, find the database associated with your WordPress installation in the left-hand sidebar.

2. Click on the database name to expand it and view the tables.

Find the wp_options Table

1. Look for the wp_options table within the selected database. The table prefix might vary depending on your setup so it could be something like wp123_options.

2. Click on the wp_options table to open it.

Edit the Site URL and Home URL

1. In the wp_options table, locate the rows with the option names site URL and home.

2. Click the Edit link (pencil icon) next to each row.

3. In the option_value field, replace the existing URL with the new URL you want.

4. Click Go to save the changes.

Note: Ensure the new URL includes the correct protocol (http:// or https://) and does not have a trailing slash.

Verify the Changes

1. After updating the URLs, visit your WordPress site to ensure it’s functioning correctly with the new URL.

2. Clear your browser cache if you don’t see the changes immediately.

Additional Considerations

1. Update Permalinks: Having trouble with links or page­s not showing up right? No worries! You can fix this in your WordPress dashboard. Update the­ permalink shape. You can find it by going to Settings, the­n Permalinks.

2. Update Database References: Let's say your we­bsite has unchanging URLs in its database, such as in articles, page­s, or special fields. In this case, you might ne­ed to look for and swap the old URL with the ne­w one. Handy tools like the Be­tter Search Replace­ plugin can assist you in this chore.

By following these steps, you can successfully change your WordPress URL using phpMyAdmin in DirectAdmin, ensuring your site runs smoothly under the new domain or URL structure.