Update the domain in the Magento 2 database

Usually, on most websites, changing the URL only requires changing the address on the web server. In the case of Magento, some additional configuration is required in the database.

Configuration

The first thing you need to do is access MySQL. You can do this with the command:

# mysql  -u usuario -p

Once inside, we will need to access the Magento database

# USE nombre_BBDD;

You can check the current address with the command:

SELECT * FROM core_config_data;

Once you have verified the path corresponding to the address, you can modify it with the command:

# update core_config_data set value = 'http:/dominio.com/' where path = 'web/secure/base_url';
# update core_config_data set value = 'http:/dominio.com/' where path = 'web/unsecure/base_url';
# update core_config_data set value = 'http:/dominio.com/' where path = 'web/secure/base_link_url'
# update core_config_data set value = 'http:/dominio.com/' where path = 'web/unsecure/base_link_url'
# update core_config_data set value = 'http:/dominio.com/' where path = 'admin/url/custom';

Once we have changed the paths for the specific domain, we will need to log in with the user account and, once in the Magento directory, clear the cache for the applied changes to take effect:

# phpX.X bin/magento cache:flush

Remember, if you have any questions about this or any other issue related to your servers on Clouding, feel free to write to soporte@clouding.io We're here for whatever you need. Just ask us!