Title: wp_users table is empty
Last modified: February 16, 2020

---

# wp_users table is empty

 *  [billgets](https://wordpress.org/support/users/billgets/)
 * (@billgets)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/wp_users-table-is-empty/)
 * in wordpress database, the wp_users table is empty, so that i can’t log in my
   website, i need a tamplate of
    INSERT INTO wp_users(ID,user_login,user_pass,user_nicename,
   user_email,user_url,user_registered,user_activation_key,user_status,display_name)
   values (what?,”what?”,”what?”,”what?”,”what?”,”what?”,’what?’,”what?”,what?,”
   what?”);
 * i need to creat a user and log in my website, please help me.
    -  This topic was modified 6 years, 3 months ago by [billgets](https://wordpress.org/support/users/billgets/).

Viewing 1 replies (of 1 total)

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [6 years, 3 months ago](https://wordpress.org/support/topic/wp_users-table-is-empty/#post-12442441)
 * Try this to add a new admin user: [https://www.wpbeginner.com/wp-tutorials/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/](https://www.wpbeginner.com/wp-tutorials/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/)

Viewing 1 replies (of 1 total)

The topic ‘wp_users table is empty’ is closed to new replies.

## Tags

 * [wp_users](https://wordpress.org/support/topic-tag/wp_users/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * Last activity: [6 years, 3 months ago](https://wordpress.org/support/topic/wp_users-table-is-empty/#post-12442441)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics