How to change base_url settings with phpMyAdmin

How to change base_url settings with phpMyAdmin

July 5, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to change base_url settings with phpMyAdmin

Solving Base_URL Inaccessibility Issues in Magento

If you’ve recently updated your base URL settings in Magento’s backend but are now unable to access your website, don’t panic—we’ll guide you through the process of resolving this issue using phpMyAdmin.

Understanding the Problem: Why You Can’t Access Your Site

When you change the base URL in the Magento backend, it updates two critical tables in your database:

  1. core_config_data: Stores the global configuration settings.
  2. core_url_rewrite: Handles the rewrites for URLs and redirects.

However, if there are any validation issues or errors during this update process, your site may become inaccessible.

Step-by-Step Solution: Accessing Your Database with phpMyAdmin

To fix this issue, follow these steps to access and modify your database using phpMyAdmin:

  1. Open phpMyAdmin: Log in to your hosting account’s control panel and navigate to the phpMyAdmin interface.

  2. Select Your Magento Database: On the left-hand side menu, find and click on the name of your Magento database.

  3. Locate the core_config_data Table: In the central pane, look for the core_config_data table.

  4. Search for the base_url Entry: Click on the ‘Search’ button at the top and enter the following in the search bar:

    • path = base_url
  5. Update or Delete the Entries:

    • If you see an entry with the correct domain but incorrect protocol (e.g., http instead of https), click on it, change the value to the desired URL, then click ‘Go’ to apply the update.
    • If the entry is completely wrong or causing a validation error, select the checkbox next to it and click ‘Delete’ at the bottom.
  6. Locate and Update/Delete Entries in core_url_rewrite:

    • Click on the core_url_rewrite table from the left menu.
    • Search for entries containing your old or incorrect base URL using the filter above the table data.

Best Practices When Changing Base_URL

To avoid such issues in the future, consider these best practices:

  • Always have a backup of your database before making significant changes.
  • Double-check your input and ensure the new URL is correct.
  • If you’re unsure about any part of the process, consult with an experienced Magento developer or reach out to our support team at Laravel Company.

Troubleshooting Additional Issues

If you’ve made the necessary changes in phpMyAdmin but are still facing issues:

  • Clear your browser cache and cookies.
  • Check your .htaccess file for any conflicting rules. If needed, refer to our guide on modifying .htaccess files.
  • Verify that there are no syntax errors in the core_config_data or core_url_rewrite tables.

Conclusion: Regaining Access to Your Magento Store

By following this step-by-step guide, you should now be able to regain access to your Magento store after changing the base URL. Remember, working directly with the database requires a careful approach to ensure data integrity and prevent potential errors.

If you find yourself stuck or need more advanced troubleshooting assistance, don’t hesitate to contact our team of Magento experts at Laravel Company. We’re always here to help!

Happy shopping!

Database Admin Configuration Customers

Our network