Migrate Drupal7 to local, user login link redirect to live, how to redirect it to local? I have changed cookies name and base URL for my local environment, I have also emptied all cache tables, but still it redirects to the live site.

Like http://server1/mysitename/user to https://www.mysitename/user
My guess is your using the secure login module.

Either:

drush vset securelogin_base_url "http://server1/mysitename/user"


or

drush dis securelogin