• Resolved WilliamKF

    (@williamkf)


    I only have one user and they are now locked out:

    You have been locked out due to too many login attempts.

    How can I edit MySQL database to unlock the one and only user?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter WilliamKF

    (@williamkf)

    I resolved this:

    In MySQL there are two tables that you can edit to clone the locked out user and make a new user that is not locked out:

    wp_users
    wp_usermeta
    In wp_users table find the locked out user row and copy it but supply new unique entries for the new user name for these columns along the lines given here:

    user_login: ‘oldUser1’ -> ‘newUser2’
    user_nicename: ‘OldUser’ -> ‘CloneUser’
    display_name: ‘User1’ -> ‘User2’
    ID: 2 -> 3
    Next, in the wp_usermeta table, copy the 18 rows that match user_id 2 and make new rows with user_id 3. For row with meta_key column value nickname give a new value.

    Having done all this, you may restart your apache server and now login using the User2 with your original password that was copied from User1 and you will have the same privileges as before and not be locked out.

    If suddenly your WordPress site gives an error ?You have been locked out due to too many login attempts.? аnd you can’t to enter in admin panel, the problem in plugin better-wp-security.

    Solutions to this problem is very simple: go to ftp to
    /wp-content/plugins/ folder and rename the better-wp-security to “_better-wp-security”.

    After that you can go back to the admin panel.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to unlock user?’ is closed to new replies.