MyBB Community Forums

Full Version: How to change a user ID?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hey

I accidently deleted my admin... I got him back but now his user ID is 3 and it bugs me as hell!!

How to fix this?

thanks Toungue
You need to edit the users table and pretty much any other table that the user has had data put into.

UPDATE mybb_tablename SET uid='1' WHERE uid='3'

I wouldn't try it, honestly. There still could be problems.
(2012-05-23, 07:27 PM)Paul H. Wrote: [ -> ]You need to edit the users table and pretty much any other table that the user has had data put into.

UPDATE mybb_tablename SET uid='1' WHERE uid='3'

I wouldn't try it, honestly. There still could be problems.

Ill just leave it Smile

Thanks anyway tho Smile