Add user directly to database

Batman or Superman?

  • Total voters


Well-known member
Hello all and everyone else too,

This isn't completely "off-topic", but it's not really a support question either, it's just a "I wonder if and how I could do that" kinda question.

Anyway, I was wondering, lets say, I lost all my users in the database, including my super admin account and I had no back ups, how would I create a new user in the database so that I could regain access to the ACP, etc?

Don't worry, this hasn't happened, it's just something I would like to know how to do in case it ever does lol

Thank you :)


XenForo moderator
Staff member
If that ever happened you would need to restore from a backup as your installation would be corrupt due to the missing user records.


Well-known member
OK, I don't know how, but for the sake of this question, what if the main Super Admin account (The one created at install) was somehow deleted, but there were still other "normal" users in the db, could one of those be made admin inside the db, then added to the config.php so that you could use that account as Super Admin to re-create new admin accounts inside the ACP?
Last edited: