Add user directly to database

[RichardKYA]

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

 

[Paul B]

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

 

[RichardKYA]

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?

 

[Paul B]

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

Yes.
It's something I've had to do on occasion for customers.