View Full Version : I delete account Amin.
azzarell
02-05-2005, 12:58
How do I create a new Admin account of zabbix? :confused:
kostas0875
08-02-2008, 15:00
I have done the same stupidity too. Can anyone help>>>.....
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
08-02-2008, 15:57
Can you give me more details as i can not understand the command
hardtofi
13-02-2008, 10:03
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
11-08-2008, 02:40
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
11-08-2008, 02:56
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