HostOnNet Blog

Change Magento 2 URL

To change Magento 2 web site URL/domain name, run following SQL commands

UPDATE core_config_data SET value = 'http://m2.hostonnet.com/'  WHERE path='web/unsecure/base_url';
UPDATE core_config_data SET value = 'http://m2.hostonnet.com/'  WHERE path='web/unsecure/base_link_url';
UPDATE core_config_data SET value = 'https://m2.hostonnet.com/'  WHERE path='web/secure/base_url';
UPDATE core_config_data SET value = 'https://m2.hostonnet.com/'  WHERE path='web/secure/base_link_url';

You need to flush cache with CLI

php bin/magento cache:flush

You can verify the URLs are set properly in DB with

MariaDB [hon_mage2]> select * from core_config_data where value like "http%";
+-----------+---------+----------+----------------------------+--------------------------+
| config_id | scope   | scope_id | path                       | value                    |
+-----------+---------+----------+----------------------------+--------------------------+
|         2 | default |        0 | web/unsecure/base_url      | http://m2.hostonnet.com/ |
|         3 | default |        0 | web/secure/base_url        | http://m2.hostonnet.com/ |
|        70 | default |        0 | web/unsecure/base_link_url | http://m2.hostonnet.com/ |
|        73 | default |        0 | web/secure/base_link_url   | http://m2.hostonnet.com/ |
+-----------+---------+----------+----------------------------+--------------------------+
4 rows in set (0.00 sec)

MariaDB [hon_mage2]> 

You can also use CLI like

php bin/magento setup:store-config:set --base-url="http://m2.hostonnet.com/"
php bin/magento setup:store-config:set --base-url-secure="https://m2.hostonnet.com/"
php bin/magento setup:store-config:set --base_link_url="http://m2.hostonnet.com/"
php bin/magento setup:store-config:set --base_link_url-secure="https://m2.hostonnet.com/"
php bin/magento cache:flush

See Magento 2


Posted in Web