Support » Fixing WordPress » Oh Shoot. I just destroyed my admin log in

Viewing 2 replies - 1 through 2 (of 2 total)
  • Using PhpMyAdmin ( or any other mysql engine )

    INSERT INTO wp_users(user_login,user_pass,user_nicename,user_email,user_status)
    VALUES (‘newadmin’, MD5(‘pass123’), ‘firstname lastname’, ’email@example.com’, ‘0’);

    INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value)
    VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’);

    INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value)
    VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_user_level’, ’10’);

    Or just go to wp_usermeta find your user , find 'wp_user_level' and change to 10

    More Here

    Thank you krembo99.

    With your help the problem is now solved.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Oh Shoot. I just destroyed my admin log in’ is closed to new replies.