I copied our EE version 2 installation to my local computer to troubleshoot something, both the database and files. I used bbedit to rename the contents of the db to my test server’s info before importing into mysql. (batch find and replace on the server IP/DNS)
I can see the login page but it’s not recognizing my password thus I can’t login at all. The ‘forgot your password’ function isn’t working and spins indefinitely.
If I use phpmyadmin, I can see my account within the exp_members table.
How can I change my password or hack my way in if I can’t login with any user? Is there a way I can do it via phpmyadmin to create a new account? I’ve tried clearing the cache. The password hash (or whatever you call it) appears to be the same on the live installation and my test installation yet it’s nothing recognizing my password on the test.
many thanks!
chris