So I was trying to install a SSL certificate on my website, and I prematurely changed the URL's in Magento from http://www.gekra-motors.nl to https://www.gekra-motors.nl.

Now it turns out my host does not support SSL. Worse, I cannot access my Magento admin panel anymore because I changed the URL's too soon.Now I can only change things in the back-end (directAdmin) and I have to change the URL's back from https to https. So does anyone have a solution or does anyone know how I can get access to the Magento admin panel?

1 Answer 1


You can update you base url using script. please check below code.

    $resource = Mage::getSingleton('core/resource');
    $connection = $resource->getConnection('core_write');

    $baseUrl = 'http://exampleurl.com/';
    $sql = 'UPDATE `core_config_data` SET `value` = "' . $baseUrl . '" WHERE `path` LIKE "%base_url%"';

using this revert your base url and access your backend.

another solution is to change base url from database.

execure this query directly into database.

UPDATE `core_config_data` SET `value` = "http://exampleurl.com/" WHERE `path` LIKE "%base_url%"

Also make sure replace "http://exampleurl.com" with your actual base url.

  • Please let me know if this solution helps you and also let me know if you need any other help as well. Commented Jun 14, 2017 at 5:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.