I accidentaly deleted admin user. Cannot login.

[ganomi]

Hi.

I was playing with users and accidentally deleted last admin account. Now I am not able to login.

How can I create new account? (maybe directly in mysql?)

I guess the system should not let to delete last admin account.

Thanks for help.

[mastertheknife]

Hi. You can re-create the admin account by running this query into MySQL. you can use phpmyadmin or the mysql executeable.
The password for the admin below is "changepassword"

Code: Select all

INSERT INTO `Users` (`Id`, `Username`, `Password`, `Language`, `Enabled`, `Stream`, `Events`, `Control`, `Monitors`, `Devices`, `System`, `MaxBandwidth`, `MonitorIds`) VALUES
(1, 'admin', '*3B34B40DAE3DD1E15943B37622F688A6D7F8002D', 'en_gb', 1, 'View', 'Edit', 'Edit', 'Edit', 'Edit', 'Edit', '', '');

[ganomi]

Thank you!

[whatboy]

I guess the USER should not delete last admin account.

[mysterylectricity]

This worked for me as well. For those of you who are not familiar with using mysql, the following commands are prerequisite:

Code: Select all

mysql -u root -p
Enter password:

If you have not set an explicit password for mysql, the system root password worked for me.

Then select the zm database:

Code: Select all

use zm;

and then:

Code: Select all

INSERT INTO `Users` (`Id`, `Username`, `Password`, `Language`, `Enabled`, `Stream`, `Events`, `Control`, `Monitors`, `Devices`, `System`, `MaxBandwidth`, `MonitorIds`) VALUES
(1, 'admin', '*3B34B40DAE3DD1E15943B37622F688A6D7F8002D', 'en_gb', 1, 'View', 'Edit', 'Edit', 'Edit', 'Edit', 'Edit', '', '');

This will set the default login to admin and the default password to changepassword.

The changes take effect immediately. Change your password and add another privileged user in case you make the same mistake again.