Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Moved DB & Now Can't Login

Moved DB & Now Can't Login

Moved DB & Now Can't Login

In late 2010 I moved a WP site & DB (Not sure what version of it is) Ever since I have not been able to login as my admin user. I have tried using the WP function to re-set my password and that process does not work. I either get a access denied or permissions error.

It is URGENT that I get in and change an old post that someone is legally threatening me about. If I can't get in I will have to take down the entire site which is an archive of thousands of posts.

If someone has instructions on how to change the password/user info via MyPhpAdmin or some other MySQL utility so I can login again I would be MOST GRATEFUL. I am under legal presure and need to do this ASAP!


RE: Moved DB & Now Can't Login

- i would suggest in the short run just logging in through phpmyadmin and manually deleting the post from the table.

using phpmyadmin and the wordpress support forum i found this simple solution

Through phpMyAdmin

This article is for those who have phpMyAdmin access to their database. Note: use phpMyAdmin at your own risk. If you doubt your ability to use it, seek further advice. WordPress is not responsible for loss of data.

Begin by logging into phpMyAdmin and click databases.
Image #2

    A list of databases will appear. Click your WordPress database.

Image #3

    All the tables in your database will appear. If not, click Structure.
    Look for wp_users.
    Click on the icon for browse.
    Locate your Username under user_login
    Click edit

Image #4

    Your user_id will be shown, click on Edit
    Next to the user_pass is a long list of numbers and letters.
    Select and delete these and type in your new password.
    Type in the password you want to use. Just type it in normally, but remember, it is case-sensitive.
    In this example, the new password will be 'rabbitseatcarrots'
    Once you have done that, click the dropdown menu indicated, and select MD5 from the menu.

Image #5

    Check that your password is actually correct, and that MD5 is in the box.

    Click the 'Go' button to the bottom right.
    Test the new password on the login screen. If it doesn't work, check that you've followed these instructions exactly.


Darryn Cooke
www.darryncooke.com | Marketing and Creative Services

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close