Create superadmin via command line

[Pierre10]

Hello,

Is there a way to create a new SuperAdmin via commands ? (mysql, php-cli, ...)

Thank you.

[NemoPS]

you can if you have database access via mysql command. You need to create an entry in ps_employee, then query for its id and create one in ps_employee_shop, setting the role to 1

[Pierre10]

I can run mysql commands. Some questions :

In ps_employee_shop, to set an admin role, I just have to set ps_shop to 1 ?

How to create a new entry the correct way ? Is it something like that ?

INSERT INTO `db`.`ps_employee` (`id_employee`, `id_profile`, `id_lang`, `lastname`, `firstname`, `email`, `passwd`) VALUES ('2', '1', '1', 'New', 'Admin', '[email protected]', 'NEWPASSWORD');

INSERT INTO 'db'.'ps_employee_shop' ('id_employee', 'id_shop') VALUES ('2', '1');

Thank you.

 

[NemoPS]

id_profile should be 1, id_shop should be your shop id, could be null, 0, or 1, or another number if you have multiple shops. Check the other entries and just conform to that. Use a real email, you will need to reset your password before you can access