I delete account Amin.

[azzarell]

How do I create a new Admin account of zabbix?

[kostas0875]

Delete admin account

I have done the same stupidity too. Can anyone help>>>.....

[SierraX]

I have done the same stupidity too. Can anyone help>>>.....

Try to create a admin account in database with the same Password of a known user.

like

mysql -u root -pblablub zabbix -e 'insert into users (alias) values (admin)'

read desc from table users and rights

1.1.4 has rights like

+---------+--------+-------------------------+------------+------+
| rightid | userid | name                    | permission | id   |
+---------+--------+-------------------------+------------+------+
|       1 |      1 | Default permission      | U          |    0 | 
|       2 |      1 | Default permission      | A          |    0 |

For admin 1.4.4 can be different.
Dump your DB before work... Work on DB can damage it.

[kostas0875]

Help!!!

Can you give me more details as i can not understand the command

[hardtofi]

Can you give me more details as i can not understand the command

How about just running the relevant sql from create/data/data.sql?

INSERT INTO users VALUES (1,'Admin','Zabbix','Administrator','d41d8cd98f00b 204e9800998ecf8427e','',900,'en_gb',30,3);
INSERT INTO users_groups VALUES (1,7,1);

[wyatt121]

Shoot!!!.. I too accidently deleted the Admin account. I can't believe this even an option. Please REMOVE this option. I tried this latter mysql command but it did not work. Anyone know how to add back the Admin account?

Wyatt

[wyatt121]

Ok... the above works perfectly, but he has an error in his command. He mistakenly has a space in the password in first line of the syntax. Here is the correction.


INSERT INTO users VALUES (1,'Admin','Zabbix','Administrator','d41d8cd98f00b 204e9800998ecf8427e','',900,'en_gb',30,3);
INSERT INTO users_groups VALUES (1,7,1);



Well it appears now that he had it correct.... but this silly forum adds the space when pasting it in...



Regards,

Wyatt