How to change Magento site URL from phpMyAdmin?

Magento is a widely used E-commerce store management system. In this article, we will show you how to change the base URL for Magento from phpMyAdmin.

  1. Login to your cPanel account.

  2. Click on phpMyAdmin under the DATABASES section.

    open phpmyadmin

  3. Select your Magento database.

    select magento database

  4. Find the table named “mg_core_config_data” and click on it.

    core-config-data

  5. At the column name path, find and update the URL in below lines. You can click the edit button and do this.

    web/unsecure/base_url
    web/secure/base_url
    


    Add the new URL with http in web/unsecure/base_url and click on the Go button.

    Add the new URL with https in web/secure/base_url and click on the go button.

Related Articles

How to setup Database Map tool from WHM Panel?

cPanel provide a feature called Database Map tool. You can provide ownership of databases and...

How to check Various cPanel logs like WHM, Apache, MySQL, Email, Error etc?

You can use cPanel to access your Linux hosting account with GUI. It is relatively easier to work...

Will internal traffic between two VPS viz. a Database Server and a Web Server be counted in my bandwidth usage?

Yes it will. The traffic will be counted in the bandwidth usage of your VPS. Even if you use...

How to Install phpMyAdmin on CentOS 7?

phpMyAdmin is a web-based GUI tool to manage your MySQL and MariaDB Databases. It is an...

How to modify the maximum number of POP3 connections in WHM/cPanel?

In case, you are getting the error Error – Maximum number of connections from user+IP exceeded...

  • 0 Users Found This Useful

Was this answer helpful?