How to create admin user

Software Support
1

Hello friends,

I migrated the OJS ploataform from version 2.2.1 to version 2.4.8-1.
I noticed that there is no admin user in the database. Instead, there is a user (ruan) who has administrative privileges.
How can I delete this user and create an admin user?
If I create a common user named admin and merge with the user ruan the user admins will inherit the administrative permissions ???

Regards,

Renato L. Sousa

2

Hi @rensousa

I think the admin user can only be created at the installation. Thus you would probably have to insert it manually in the DB – in the DB table users and roles (with journal_id = 0 and role_id = 1).
How was that user (ruan) with administrative privileges created and how do his entries in the DB look like?

Best,
Bozana

3

Hello @bozana

I used the mysql UPDATE command to directly change the username ruan to admin in the database.
I think it worked!

Regards

Renato L. Sousa

4

Hi, Can you help me? I have the same problem, but I don´t find the exactly table on my Data base. What is the correct table and lines. Thank you

5

Hi @mc_mpz,

…you would probably have to insert it manually in the DB – in the DB table users and roles (with journal_id = 0 and role_id = 1)…

Clear?

Best,
Bozana