WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Can't login to Admin panel (20 posts)

  1. davegrun
    Member
    Posted 2 years ago #

    Starting from last week I can't get into the Dashboard/Admin panel. This happened out of the blue and I did nothing out of the ordinary. The blog has been running for at least 2 years with no problems. I tried adjusting the password using PhpMyAdmin; I deleted the wp-login.php file and uploaded a fresh one; I tried to reset using email. None of this works.
    So now I can't write posts, can't field comments. Can't do anything.

    The blog is blog.gts-translation.com

    Thanks in advance for help

  2. esmi
    Forum Moderator
    Posted 2 years ago #

    What happens when you try to login?

  3. davegrun
    Member
    Posted 2 years ago #

    Thanks. I get "ERROR: The password you entered for the username admin is incorrect. Lost your password?"

  4. esmi
    Forum Moderator
    Posted 2 years ago #

    Can you try resetting your password in the database again but this time, follow the steps outlined in http://www.tamba2.org.uk/wordpress/phpmyadmin/

  5. davegrun
    Member
    Posted 2 years ago #

    Thanks but it does not work and I followed it to the letter

  6. esmi
    Forum Moderator
    Posted 2 years ago #

    That sounds like database damage. Have you tried repairing your database's tables?

  7. davegrun
    Member
    Posted 2 years ago #

    Thanks esmi, I played around with that now and did a repair operation on all the blog DB tables. It said that it worked but still the problem persists. I should add that the blog displays OK just the Admin does not. Can you be more specific on what repair operations to make?

  8. esmi
    Forum Moderator
    Posted 2 years ago #

    When you add the new password, are you MD5 encrypting it?

  9. davegrun
    Member
    Posted 2 years ago #

    yes I am

  10. esmi
    Forum Moderator
    Posted 2 years ago #

    Have you checked your server's error logs for clues?

  11. davegrun
    Member
    Posted 2 years ago #

    I am not an expert in sysadmin so don't know what logs to look for. I have WHM Cpanel, what should I look for?

  12. esmi
    Forum Moderator
    Posted 2 years ago #

    Try looking for any errors relating to the MySQL server.

  13. davegrun
    Member
    Posted 2 years ago #

    Hi @esmi, now the PhpMyAdmin is showing that the wp_user and wp_usermeta tables are marked as crashed and should be repaired. But it does not let me repair these tables. Questions: (a) if I truncate these tables will I be able to login as Admin. (b) I have old backups of the database. Should I try and restore the two damaged tables from their? What do you think I should do?

  14. davegrun
    Member
    Posted 2 years ago #

    Hi, I managed to solve this issue using a workaround: (1) I registered as a new user; (2) I assigned the user with Admin rights in PhpMyAdmin; (3) I changed the password of the new Admin user in PhpMyAdmin. Now I can access the Dashboard. Thanks, David

  15. latenitesero
    Member
    Posted 2 years ago #

    now very simple, go do PhpMyAdmin find user, admin , and set new password, choose Md5 when u save the new passwords

  16. davegrun
    Member
    Posted 2 years ago #

    Hi @latenitesero, thanks. I tried that but it did not work. I had to create a new Admin user. I have no idea why this happens but as long as I can access the Dashboard it is a good solution for me.

  17. latenitesero
    Member
    Posted 2 years ago #

    well, that good too, now i need your help, can you check my post ? in the same page ( Starting with Warning: Cannot modify header information )

  18. esmi
    Forum Moderator
    Posted 2 years ago #

    @latenitesero: Please stick with your existing topic for this.

  19. davegrun
    Member
    Posted 2 years ago #

    I would like to add for posterity and for the benefit of people that will have this problem in future that the problem was created due to lack of disk space and a heavily inflated SQL database. That evidently cause some database corruption. Thanks again @esmi for your help.

  20. esmi
    Forum Moderator
    Posted 2 years ago #

    Thanks for posting the details. :-)

Topic Closed

This topic has been closed to new replies.

About this Topic