I have deleted the super admin user, how can i do to create a new ?

[niak]

Hi everybody :)

I have deleted the super admin user, how can i do to create a new super admin user ? :eek:

Thanks in advance for your help !:)

[Calimero]

Insert a new user in 'users' table with type=3, maybe ?

Passwords are simple MD5 hashes so you can generate the new password with MySQL's builtin MD5() function.

[dotneft]

INSERT INTO users VALUES (1,'Admin','Zabbix','Administrator','5fce1b3e34b52 0afeffb37ce08c7cd66','',0, 900,'en_gb',30,3,'default.css',0,'',0);
INSERT INTO users VALUES (2,'guest','Default','User','d41d8cd98f00b204e9800 998ecf8427e','',0,900,'en_gb',30,1,'default.css',0 ,'',0);

../create/data/data.sql

[niak]

OK thank you very much for reply :) It's work !

Here there is a function to translate password in md5 password (the site is in french) http://www.bibmath.net/crypto/moderne/md5.php3 :cool:

Bye :)

[Calimero]

You can also use MySQL's built-in md5 function:

SELECT MD5('whatever');

[niak]

Exactly, this function works very good ! thx :)