Using phpMyAdmin from the DirectAdmin panel, you can manually alter a WordPress URL. You can change your domain name or the installation path for WordPress with it.
Your WordPress site’s URL may occasionally need to be manually changed in the database.
As an illustration, suppose your domain name changes in the DirectAdmin account. The domain name will only alter in the DirectAdmin panel—not in the database—if WordPress has been installed.
Using phpMyAdmin in DirectAdmin to Modify the WordPress URL,
Prior to changing the URL of the WordPress website, you must first look up the database name that is being used for that site.
1.Access the DirectAdmin panel by logging in.
2. Go to the Files & System Info area and select File Manager.
3) The “home” directory is where the File Manager opens by default. After giving it a double-click, open the public_html directory. Your files that are available to the public are located in this directory.
4) All of your WordPress files will be visible to you after navigating to the public_html directory. It is important to keep in mind that you will need to navigate into the location where WordPress was installed, if it was anywhere else than “wp,” “blog,” etc.
Locate the file “wp-config.php” and use the right-click menu to select “Edit.”
5) Your browser should open the wp-config.php file in a new tab once you click on View. Proceed to the part marked /* The name of the WordPress database* line and scroll down to discover it.
As you can see, the database is called “hosttest_wp99.” This entry won’t follow the same format in your circumstance.
You must now find a database in phpMyAdmin.
6) Return to DirectAdmin and navigate to the Extra Feature area. Click on phpMyAdmin there.
7)You can observe that your browser will open phpMyAdmin in a separate tab. Locating the database name that you previously determined by looking at the wp-config.php file will be your task going forward. Make sure the database you select is the one that is explicitly mentioned in the wp-config.php file from the previous step if you have several databases. To enlarge the tables, click the plus + symbol now.
8)Following table expansion, find the wp_options table. Just search for the second prefix, _options, as your database’s prefix doesn’t have to be wp_.
Once you’ve located the _options table, click on it to see the entries. Decide the two entries you wish to change:
Next, locate the entries that are named:
– option_name: siteurl
– option_name: home
The URL name appears in the area under option value.
Click the edit option to add a new domain after the URL entries have been identified. Use “http://” or “https://” when entering the URL.
Click the Go button once your domain name has been entered.
9) After that, you’ll be taken back to the previous page so you may complete the second entry. Verify that the entries you made match one another. Click “Go.”
10)Your WordPress website will open correctly using the new URL once you have updated both of them.
