Title: user name deleted
Last modified: August 19, 2016

---

# user name deleted

 *  [taiyabs](https://wordpress.org/support/users/taiyabs/)
 * (@taiyabs)
 * [16 years, 5 months ago](https://wordpress.org/support/topic/user-name-deleted/)
 * Hi there,
 * From site (self hosted, wordpress 2.8.5) user name (i had two user name) deleted(
   as i was trying log in, it says no user name available). If there is no user 
   name left, how can I set new one…

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [16 years, 5 months ago](https://wordpress.org/support/topic/user-name-deleted/#post-1273500)
 * Just visit your [Administration](http://codex.wordpress.org/Administration_Panels)
   > [Users](http://codex.wordpress.org/Administration_Panels#Add_New_User) > [Add New](http://codex.wordpress.org/Users_Add_New_SubPanel)
   to create a new user.
 * If you can’t login review [Resetting Your Password](http://codex.wordpress.org/Resetting_Your_Password).
 *  Thread Starter [taiyabs](https://wordpress.org/support/users/taiyabs/)
 * (@taiyabs)
 * [16 years, 5 months ago](https://wordpress.org/support/topic/user-name-deleted/#post-1273578)
 * to visit Administration > Users > Add New to create a new user. I HAVE TO LOG
   IN. But main problem is no user name left in the database. In this situation 
   how can I create a user name…?
 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [16 years, 5 months ago](https://wordpress.org/support/topic/user-name-deleted/#post-1273582)
 * Backup your database.
 * Then, in your wp-config.php, change the $table_prefix to something different.
   Then visit yourdomain.com/wp-admin/install.php and let WordPress install a 2nd
   set of database tables, including an “admin” user, then copy the record from 
   the user table and the records (multiple) from usermeta to your other user and
   usermeta tables. Then change the $table_prefix back to the original value.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘user name deleted’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [MichaelH](https://wordpress.org/support/users/michaelh/)
 * Last activity: [16 years, 5 months ago](https://wordpress.org/support/topic/user-name-deleted/#post-1273582)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics