We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Changing the admin user | Forum

Topic location: Forum home » Support » General Questions
mahmood
mahmood Oct 4 '18

I want to change the admin account. How can I do that?

Currently, USER1 is the admin who installed the oxwall website. Now, I want to create USER2 and swap the accesses. Therefore USER1 will become a normal user who has no access to the admin panel.


Mike
Mike Oct 5 '18

Hey, you cant do that in the UI.


But you can remove the user ID from the actual admin from the database table `ow_base_authorization_moderator`


! Make sure you have added an other admin before !

mahmood
mahmood Oct 5 '18

So, id=1 is the admin.


mysql> select * from ow_base_user where id=1;

+----+----------------------+-----------+------------------------------------------------------------------+------------+---------------+----------------------------------+-------------+-----------+

| id | email                | username  | password                                                        

| joinStamp  | activityStamp | accountType                      | emailVerify | joinIp    |

+----+----------------------+-----------+------------------------------------------------------------------+------------+---------------+----------------------------------+-------------+-----------+

|  1 | MYEMAIL | MAHMOOD | 20e5d8877b59322368c11568157c9a1d11fee48a3c0d70c11

| 1526916930 |    1537018448 | 290365aadde35a97f11207ca7e4279cc |           1 | 622865025 |

+----+----------------------+-----------+------------------------------------------------------------------+------------+---------------+----------------------------------+-------------+-----------+

1 row in set (0.00 sec)


mysql> select * from ow_base_authorization_moderator;

+----+--------+

| id | userId |

+----+--------+

|  1 |      1 |

|  3 |     74 |

+----+--------+

2 rows in set (0.00 sec)


Should I simply change the id=1 to another number, e.g. 200 and then change the id of the newly added user to 1?

Mike
Mike Oct 5 '18

In "ow_base_authorization_moderator" just replace the userid to the userid of the new admin in the first item.


So it should be:

+----+--------+

| id | userId |

+----+--------+

|  1 |   152 |

|  3 |     74 |

+----+--------+