how to reset the Admin password without gui access

[mrmurdock]

The title says it all. Its zabbix 1.8. Thank you. I know it must be a database command, but, not familiar enough with mysql to do it.

[nelsonab]

In the user table set the password for the admin user to blank. Then you can log in without a password, however you will need/want to change it to something with a password quickly. :-D

[mattlf]

Hi

Our sysadmin left and I have to get into zabbix and try to get access to the super user

In the user table I set the password for the admin user to blank

update users set passwd='' where name='Zabbix';

mysql> select name, alias, passwd from users where name='Zabbix';
+--------+-------+--------+
| name | alias | passwd |
+--------+-------+--------+
| Zabbix | Admin | |
+--------+-------+--------+

I restarted zabbix : ./zabbix_agentd stop; ./zabbix_agentd start

However, when trying to log in, I get

ERROR: Login name or password is incorrect

I would appreciate any help. Is there some logging I can turn on to see what is happening

Thank you

[mrmurdock]

Fortunately for me I was just at install so I dropped the database and re-created it from scratch.
However, Mysqladmin makes sure the password is encrypted. I using RHEL5, with 5.0 of mysql.
From the linux shell as the root user,

mysqladmin -u <user> password '<new_password>'
mysqladmin -u <user> -h <host> password '<new_password>'

[mattlf]

Thank you for your reply.
But this would be for the mysql user
I am actually trying to reset the zabbix admin/super user password
And this does not work for me

[mrmurdock]

Go to www.mysql.com and do a search for Mysql 5.0 Manual...
thats about as much as I can do.

[richlv]

update zabbix.users set passwd=md5('mynewpassword') where alias='Admin';

[mattlf]

cool. it works. Thanks a lot
I had to restart the web server as well

[chocho63]

Help password

I've just upgraded to 1.8.1 from 1.1.
Can't connect... This SQL statement works, but I still can't connect...

[aic]

Hi All,

Please help I will need to do the same for Oracle environment....

Thanks!

[nelsonab]

aic, have you tried any of the above?

[walterheck]

on a sidenote: shouldn't the password be salted in the database?

[aic]

Hi nelsonab,

Actually, I didn't tried the options suggested above because I am using Oracle Database instead of MySQL.

I fixed this issue applying the default hash (password) for Admin user.

Anyway, thanks for your reply!

Have a good week.

[zhanghui8059]

Hi nelsonab,

Actually, I didn't tried the options suggested above because I am using Oracle Database instead of MySQL.

I fixed this issue applying the default hash (password) for Admin user.

Anyway, thanks for your reply!

Have a good week.

Hi，
I use oracle database,and use update users set passwd=hash(password) where name='zabbix';
but oracle error is not hash,pls help,how are you doing?THKS!

[igalsc]

update zabbix.users set passwd=md5('mynewpassword') where alias='Admin';

Thank you, this worked for me with Zabbix 5.2