Lewati ke konten utama
Hubungi kami
Nomor dan waktu telepon
Pusat Bantuan

Jelajahi sumber daya bantuan online kami

Bantuan

GoDaddy Bantuan

Create an admin user in the WordPress database

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

  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 column before continuing to the next step.

  2. In the left menu, select the wp_users table.
  3. Select Insert.
  4. Enter the following:
    Field What it is...
    ID Any number that isn't already used by another user
    user_login Username for accessing the WordPress dashboard
    user_pass Password for this user

    Note: Make sure to select MD5 in the functions menu.

    user_nicename The nickname for this user
    user_email Email address for this user
    user_registered Date and time this user was registered
    user_status Set this to 0
    display_name Name that will display for this user

  5. Select Go.
  6. Select the wp_usermeta table.
  7. Select Insert.
  8. Enter the following:
    Field Whatit is...
    user_id Enter the ID from step 4
    meta_key Enter wp_capabilities

    Note: For Managed WordPress accounts or custom database table prefixes, include the prefix (e.g. wp_coolPrefix_capabilities).

    meta_value Enter the following:
    
    a:1:{s:13:"administrator";s:1:"1";}

  9. Select Go.
  10. Select the Insert tab again.
  11. Enter the following:
    Field What it is...
    user_id Enter the ID from step 4
    meta_key Enter wp_user_level

    Note: For Managed WordPress accounts or custom database table prefixes, include the prefix (e.g. wp_coolPrefix_user_level).

    meta_value Enter the number 10

  12. Select Go.

The admin user is now ready to log n with their username and password.

More Info

Terkait Komunitas

stav's Avatar
Create new user in my MySQL Database

1 Balasan

Last posted over 4 years ago.

Charliep's Avatar
Cannot access new database from within Wordpress (PHP)

1 Balasan

Last posted over 2 years ago.

m_ghafoori's Avatar
Add new user to MySql databse

1 Balasan

Last posted over 3 years ago.

designcoup's Avatar
Migrating with Back-up Buddy

1 Balasan

Last posted over 4 years ago.

user2001's Avatar
MYSQL error can't connect to an unknown database

2 Balasan

Last posted almost 4 years ago.

Tidak menemukan yang Anda cari? Cari Komunitas