Force login through mysql 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
Sounds like you need to do the following:


Set the securepages_enable to 0 in settings.php 
Open a MySQL Client, like HeidiSQL or SQL Pro 
Truncate the cache_ tables
Reload local site in browser


This should rebuild the variables and then your runtime value will be respected.

Also, check the .htaccess file to see that you are not being redirected to HTTPS.