I have a local install of a Drupal 7 site that will only display admin pages over https such as login and admin type pages. I was unable to disable them before downloading the database. In settings.php I have set secure pages to 0. However when i attempt to login the page simply refreshes and the form is displayed again and i am unable to visit any admin pages. Is there a way to login using mysql instead of having to go through Drupal?
EDIT:
finally got drush running correctly and used drush cc all after attempting to sign in i got the error message: Warning: Cannot modify header information - headers already sent in _drupal_bootstrap_page_cache() Warning: Cannot modify header information - headers already sent in drupal_send_headers()
the latter is repeated 7 times, the page simply refreshed again.
I ended up creating a temporary sign-in using drush command: drush user-login