Support » Localhost Installs » password issue going from production to local

  • I have wp set up locally. When I download a backup of my site and import it, I log in and of course it takes me right back to the commercial site. When I change the home and siteurl in wp_options I try to log in and get a password failure whether I use the local passord or the production password (which I assume is what I imported with the database). What else do I have to change besides wp_options in order for this to work on my local machine?

    I don’t want to make any changes locally and upload them until I get this figured out for fear I’ll wind up locking myself out of the production environment.

Viewing 6 replies - 1 through 6 (of 6 total)
  • How exactly are you backing your site up and setting it up locally? The built in import/export tools simply import and export the content. You’ll have to setup the user accounts and passwords separately.

    If you want to duplicate a site to work on it locally, I would recommend using other plugins made specifically for that purpose which duplicate or backup the entire site (content, themes, widgets, database, etc.) and let you restore it to a different server. Domain name changes are handled automatically.

    A popular free tool is Duplicator ( Very easy to use. If you are duplicating the site locally you’ll need a local host environment which you can easily setup with Xampp, MAMP, WAMP, Bitnami or InstantWP.

    BackupBuddy is a popular premium plugin that does the same thing plus scheduled backups to any other location ( It starts at $75/yr.

    If you plan on doing this often, an excellent tool for local development then publishing online is DesktopServer by It costs $50 for the premium version and supports importing backups from Duplicator, ManageWP and InfiniteWP. It creates its own hosting environment so there is no need for MAMP, Xampp, etc. There is a Windows and Mac version. The free versions of and let you do manual backups of your site.

    Thanks for the reply. I’ll try that free plugin first and see if that does the trick

    Can’t thank you enough for pointing me to that duplicator plugin. I spent 5 days beating my head against the monitor over that one. The plugin solved it for me in about 15 minutes!

    I’m glad I could help out. That’s what these forums are all about.



    @pvteyez I know your issue is resolved but I thought I’d chip in with an alternative method.

    Our setup uses a local, staging and production model so I’m always moving DB’s from one machine to another.

    I do it manually.

    1. Export your DB from PHPMyAdmin using @replace
    2. Load into notepad
    3. Search and replace http://stagingservername with
    4. Import the new SQL to the new DB


    Thank you for that Lime Canvas

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘password issue going from production to local’ is closed to new replies.