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.
We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
Changing the admin user | Forum
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
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
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 |
