WordPress.org

Ready to get started?Download WordPress

Forums

Can't log in (20 posts)

  1. rippert
    Member
    Posted 4 years ago #

    Have been logged in as Admin with a password that I wrote down and been creating a site for 'weeks' when I found it nessesary to log out. Now can't log back in. Won't accept the password. Tried multiple other passwords and nothing works. Clicked 'Lost your password?', entered the email address and clicked 'Get New Password'. Checked email & it said my username was now 'X' (which I recognized, so I must have changed it, even tho I've read that you can't change 'admin', you can only create a new account and give it admin permissions) and generated a new random password. Can't log in with that either. Click on 'Lost Your Password' - visious cycle. Tried several solutions here, including: Cleared browser (IE8) cache and cookies, disabled plugins, uploaded fresh login file. Stopped short of editing the users table. Must be something simpler. Please help.

  2. Have you tried resetting the password in the database?

    http://codex.wordpress.org/Resetting_Your_Password#Through_phpMyAdmin

  3. rippert
    Member
    Posted 4 years ago #

    This did not work. It is still telling me the password is incorrect. Is it true that the username must be admin?

    Thanks for responding.

    Rip

  4. rippert
    Member
    Posted 4 years ago #

    OK, now I can get in with the latest password they sent me via email and the username 'X' from above, but I can only see a 'Global Dashboard', not any of my old dashboard with my pages, editor etc. Whats happened? I need to get to the dashboard that runs my site.
    Thanks,

    Ripper

  5. rippert
    Member
    Posted 4 years ago #

    Incidentally, the wp_users table has 3 fields: user_login, user_nicename and display_name, and they all say 'admin'. I just don't get this. Can anyone enlighten me?
    Thanks,

    Rip

  6. Go to the wp_usersmeta table via phpMyAdmin and check the wp_user_level column. An administrator should be level 10. If it isn't, try changing it to 10.

  7. rippert
    Member
    Posted 4 years ago #

    There are only 4 columns:

    umeta_id
    user_id
    meta_key
    meta_value

  8. Sorry, I meant "row" instead of "column". Look for the wp_user_level row. An administrator should be level 10. If it isn't, try changing it to 10.

  9. rippert
    Member
    Posted 4 years ago #

    Can't find wp_user_level. There are 14 rows. No #6. Left off the meta_value column. First column is umeta_id, second is user_id, third is meta_key.

    1 1 nickname
    2 1 rich_editing
    3 1 comment_shortcuts
    4 1 admin_color
    5 1 wp_capabilities
    7 1 wp_usersettings
    8 1 wp_usersettingstime
    9 1 wp_metaboxorder_post
    10 1 screen_layout_post
    11 1 wp_autosave_draft_ids
    12 1 wp_metaboxorder_page
    13 1 screen_layout_page
    14 1 closedpostboxes_dashboard
    15 1 metaboxhidden_dashboard
    Thanks again!

    Rip

  10. That's a big problem. I have a feeling that the user may be gone, or that the database is irreparably damaged.

    Check wp_users . Is your user still listed there?

    Do you have a backup to restore from?

  11. rippert
    Member
    Posted 4 years ago #

    Yes, that's where I originally changed my password.

  12. That's good, but you're still missing some key tables in wp_usersmeta . You basically have a user, but it's a user that cannot be recognized by WP. The only thing that I can think of is that you were possibly hacked. Do you have a backup to restore from?

  13. rippert
    Member
    Posted 4 years ago #

    No. I'm not sure what or how to back up. I'm very new at this. I suppose I should back up the DB, but don't know how. I am still able to 'get' the files off the server via FTP. That would at least preserve all the work I put into it. Or do you not recommend that if I was hacked?

  14. No, most of your content is stored in the database. The only thing that you could preserve by downloading the files would be any changes that you made to the design.

    You should get in touch with your hosting provider and ask if they have a backup for your account before the incident.

    There probably is a way to fix the database, but I have never done it myself. When working with the database, assumptions on what to do can sometimes cause more damage than good. If your hosting provider doesn't have a backup, it may be a good idea to wait and see if someone else here has had experience fixing a database problem like this.

  15. rippert
    Member
    Posted 4 years ago #

    I think I'll ditch the whole thing and start over. All the time I invested was mostly learning; there was actually very little content. And I'll figure out how to back everything up!

    Appreciate the help. Thanks again.

    Rip

  16. You're welcome! When you're all setup again, this guide details a few backup methods:

    http://codex.wordpress.org/Backing_Up_Your_Database

  17. rippert
    Member
    Posted 4 years ago #

    Hey, I've set up the whole thing all over again and after setup and install, I went to phpMyAdmin to check for the values you talked about and their still not in the wp_usermeta table. These are the rows:

    1 1 nickname
    2 1 rich_editing
    3 1 comment_shortcuts
    4 1 admin_color
    5 1 wp_capabilities
    6 1 default_password_nag
    7 1 wp_usersettings
    8 1 wp_usersettingstime

    Don't see a reference to user level in any of the tables. Is it needed?
    Thanks.
    Rip

  18. Did you do a manual installation or an automatic installation, and are you able to login successfully?

  19. rippert
    Member
    Posted 4 years ago #

    Automatic. And I've logged in and out several times now cause I'm nervous. So far so good...

  20. Doing a manual installation is always better than an automatic one. I'm "old-school" and just don't trust those things. But, if everything is working fine, you might as well keep it as it is.

Topic Closed

This topic has been closed to new replies.

About this Topic