Posted on December 2, 2020 by jamie

mysql -u [user] -p [password]

SHOW databases;

USE [datbase_name];

SELECT path,value FROM core_config_data WHERE path LIKE 'web/unsecure/base%';

SELECT path,value FROM core_config_data WHERE path LIKE 'web/secure/base%';

UPDATE core_config_data SET value = 'http://www.example.com/' WHERE path LIKE 'web/unsecure/base_url';

UPDATE core_config_data SET value = 'https://www.example.com/' WHERE path LIKE 'web/secure/base_url';
Clear / Update cookie
SELECT * FROM core_config_data WHERE path = 'web/cookie/cookie_domain';

UPDATE core_config_data SET vale = NULL  WHERE path LIKE 'web/cookie/cookie_domain';