Skip to content

Instantly share code, notes, and snippets.

@damaya

damaya/Reset magento admin password from mysql

Created July 28, 2015 03:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save damaya/6869c0d16add3b32c810 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save damaya/6869c0d16add3b32c810 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Reset magento admin password from mysql
UPDATE `admin_user` SET `password` = MD5('newpassword') WHERE `username` = 'adminusername';
@damaya

damaya commented Jul 28, 2015

Copy link
Copy Markdown
Author

select * from core_config_data where path like 'web/unsecure/base_url';
update core_config_data set core_config_data.value='http://magento.bitbang.co/' where core_config_data.config_id=1440;
update core_config_data set core_config_data.value='http://magento.bitbang.co/' where core_config_data.config_id=1441;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment