How to remove https from admin panel in magento database as getting 403 error

How to remove https from admin panel in magento database as getting 403 error

July 24, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to remove https from admin panel in magento database as getting 403 error

Solving Magento Admin Panel HTTPS Redirect Issues

Understanding the Problem

When configuring your Magento store, it’s crucial to set up the secure URLs correctly. If you mistakenly set the admin panel to use ‘https’ instead of ‘http’, you may encounter a dreaded 403 Forbidden error upon login.

In such cases, you’ll likely find that the necessary database tables—specifically core_config_data—are already configured properly with web/secure/use_in_frontend, web/secure/use_in_adminhtml, and web/secure/offloader_header all set to their correct values. However, the issue persists due to cached data.

Debugging the Problem

Step 1: Flush Magento Cache

Before diving into database manipulation, let’s ensure that you’ve flushed your Magento cache completely. You can do this directly from the admin panel:

  • Navigate to System > Tools > Cache Management.
  • Select all types (Configure Cache, Layout XML, etc.).
  • Click on the Flush button.

Alternatively, you can manually delete the contents of the var/cache directory via FTP or SSH. However, be cautious when deleting files directly from the server, as it can disrupt other processes running simultaneously.

Database Configuration Checks

Step 2: Verify core_config_data Values

Double-check that your database is indeed configured correctly:

SELECT * FROM core_config_data WHERE path LIKE 'web/secure/%';

The expected output should be:

| path                                      | value | scope          |
|------------------------------------------|-------|---------------|
| web/secure/use_in_adminhtml              | 0     | default       |
| web/secure/use_in_frontend               | 0     | default       |
| web/secure/offloader_header             | SSL_OFFLOADED | default       |

Ensure that the scope is set to default, and the values are consistent with the table above.

Resolving the Issue

Step 3: Clear Session Data

Even after flushing the cache, session data might be causing the redirection issue. To resolve this:

  • Navigate to your Magento root directory via FTP or SSH.
  • Locate the var/session directory and delete its contents.

Be careful not to remove the entire directory—only its contents. This action will ensure that any session-related information is cleared from the system.

Step 4: Manually Update Base URLs

In rare cases, you might need to update the base URLs manually:

  • Login to your database using a MySQL client or PHPMyAdmin.
  • Execute the following SQL query:
UPDATE core_config_data SET value = CONCAT('http://', domain) WHERE path LIKE 'web/unsecure/%';

Replace domain with your actual domain name. This query updates all unsecured URLs in the database to use ‘http’ instead of ‘https’.

Conclusion

Resolving Magento HTTPS Redirect Issues Successfully

When facing a 403 Forbidden error due to incorrect SSL configuration, remember that flushing cache and clearing session data are your primary tools for troubleshooting. Always ensure that you have:

  • Properly configured the core_config_data table.
  • Flushed all types of cache from the admin panel or manually via SSH/FTP.
  • Cleared the contents of the var/session directory.

If the issue persists, consider updating the base URLs manually as a last resort. Be sure to backup your database before making any direct changes.

Further Reading

For more in-depth guidance on Magento configuration and troubleshooting, I highly recommend exploring the Magento DevDocs and checking out our comprehensive guides at Laravel Company.

Happy coding!

Cache Database Themes Admin

Our network