Change my UID

[Hostpro]

Hey,

Is it possible to change my UID to 1?

I have an admin account which is UID 1 but my UID is 6 and I'd like it to be one, is this possible?

URL - http://theprofiters.com

~Hostpro

[Yaldaram]

AdminCP > Users and Groups > Merge Users >

[ksr]

Goto PHPAdmin ==> select your database ==> select mybb_users table ==>

1)Check if there is any user with UID 1
2)If no one have UID 1, then goto your field and replace your UID with 1 by editing direcly or with the following sql command

update table mybb_users set uid=1 where uid=6;

[Hostpro]

AdminCP > Users and Groups > Merge Users >

What does merge users do exactly?

Some questions:

Do the post counts merge together?
Which username does it choose from?
What UID would it be if I merge 1 and 6?
Which password would it pick?

etc

~Hostpro

[ksr]

AdminCP > Users and Groups > Merge Users >

What does merge users do exactly?

Some questions:

Do the post counts merge together?
Which username does it choose from?
What UID would it be if I merge 1 and 6?
Which password would it pick?

etc

~Hostpro

Have you tried the above procedure that i have given?

[Yaldaram]

By merging the users you wouldn't lose any posts/threads made by any of the two users. However with changing the UID you'll lose many posts as well as come up with broken holes scattered around the forums.

[Hostpro]

AdminCP > Users and Groups > Merge Users >

What does merge users do exactly?

Some questions:

Do the post counts merge together?
Which username does it choose from?
What UID would it be if I merge 1 and 6?
Which password would it pick?

etc

~Hostpro

Have you tried the above procedure that i have given?

I already have a UID-1

[Hostpro]

Goto PHPAdmin ==> select your database ==> select mybb_users table ==>

1)Check if there is any user with UID 1
2)If no one have UID 1, then goto your field and replace your UID with 1 by editing direcly or with the following sql command

update table mybb_users set uid=1 where uid=6;

if someone is already in user id 1 then how to exchange his user id with own?

just for example, if my user id is 8 and someone is with user id 1, if i will go to user id 1 then how to give him user id 8...meance exchange the both user ids!

That's exactly what I'm looking for.

[Yaldaram]

As I said, the best way is to "merge" these two users. By merging you wouldn't loose any data.

Do the post counts merge together?

Yes.

Which username does it choose from?

Every thing is clearly written on the merge page.

What UID would it be if I merge 1 and 6?

In your case, UID 6 is a "Source Account" and UID 1 is "Destination Account".

Which password would it pick?

After the merge the password would be the same as the password of UID 1

[ksr]

Goto PHPAdmin ==> select your database ==> select mybb_users table ==>

1)Check if there is any user with UID 1
2)If no one have UID 1, then goto your field and replace your UID with 1 by editing direcly or with the following sql command

update table mybb_users set uid=1 where uid=6;

if someone is already in user id 1 then how to exchange his user id with own?

just for example, if my user id is 8 and someone is with user id 1, if i will go to user id 1 then how to give him user id 8...meance exchange the both user ids!

That's exactly what I'm looking for.

You can temporarily assign a uid(Any uid, check the last registered user's uid and assign one without conflicting to others) for the user having uid '1' and then assaign uid '1' to your account, after that you can assaign back the uid '8' to user.

Just give a try, i am not sure about it.

DON'T FORGET TO BACKUP YOUR SQL DATABASE BEFORE DOING ANY OPERATIONS ON DATABASE.