Create a new WordPress admin user in the database

You can create a new WordPress admin user from within the database. Use this method if your original admin user was

  1. Log into phpMyAdmin (cPanel / Plesk / Web Hosting / Managed WordPress).

    Note: If you're using cPanel Hosting, you must select the database for your WordPress site in the left-hand column before proceeding to the next step

  2. Click the _users table
  3. Click the Insert tab
  4. Fill in the following fields.
    • ID is any number you choose
    • user_login is the username for accessing the WordPress Dashboard.
    • user_pass is the password for the user. Make sure to select MD5 in the functions menu
    • user_nicename is the nickname for the user
    • user_email is the email address you want to associate with this user
    • user_registered is the date and time for when this user is registered
    • user_status should be set to 0
    • display_name is the name that will be displayed for this user on your site
  5. Click the Go button
  6. Click the _usermeta table
  7. Click the Insert tab
  8. Fill in the following fields:
    • user_id is the ID you entered in the previous step
    • meta_key should be the phrase wp_capabilities
    • meta_value should be
      a:1:{s:13:"administrator";s:1:"1";}
  9. Click Go
  10. Click the Insert tab again
  11. Enter the following information:
    • user_id is the same number you entered in the previous step
    • meta_key should be the phrase wp_user_level
    • meta_value should be the number 10
  12. Click the Go button.

You can now login with the new Admin user.

More Info

More info about WPPS.

이 글이 도움되었나요?
피드백을 보내주셔서 감사합니다. 고객 서비스 담당자에게 문의하시려면 지원 전화 번호 또는 위의 채팅 옵션을 이용하시기 바랍니다.
도와드릴 수 있어 기쁩니다! 더 도와 드릴 것이 있나요?
그것 유감스럽습니다. 혼동이 되었던 사항 또는 솔루션이 고객님의 문제를 해결하지 못했던 원인을 알려주세요.