Reset “Use Secure in Front End or Admin” in Database – Magento 2

If you ran into a problem like you have changed the secure admin URL back to non secure URL and you forgot to change the Use Secure in Front End or Admin to zero -means disable. It’s total mess that you cannot access the admin side again as all the JavaScript and CSS urls will have https prefix and all will be showing 404 .The only solution is deep diving in to the database.

Follow the steps

1. Open your database admin tool such as PhpMyAdmin
2. Find table “core_config_data”
3. Search for the columns in path field  “web/secure/use_in_frontend” and “web/secure/use_in_adminhtml”
4. Set both values to 0, then clear cache and enjoy browsing your website.