ZABBIX Forums  
  #1  
Old 28-01-2010, 19:59
mrmurdock mrmurdock is offline
Member
 
Join Date: Aug 2009
Posts: 70
Default how to reset the Admin password without gui access

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.
Reply With Quote
  #2  
Old 28-01-2010, 20:41
nelsonab nelsonab is offline
Senior Member
Zabbix Certified Specialist
 
Join Date: Sep 2006
Location: Virginia
Posts: 1,205
Default

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
__________________
RHCE, Author of Zabcon, the Zabbix Cli Tool, and the Zabbix API Ruby Library Gem (zbxapi)
http://trac.red-tux.net

Unofficial Zabbix mirror and source code cross reference:
http://ztrac.red-tux.net

Reply With Quote
  #3  
Old 05-02-2010, 21:21
mattlf mattlf is offline
Junior Member
 
Join Date: Feb 2010
Posts: 8
Default

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
Reply With Quote
  #4  
Old 05-02-2010, 21:26
mrmurdock mrmurdock is offline
Member
 
Join Date: Aug 2009
Posts: 70
Default

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>'
Reply With Quote
  #5  
Old 05-02-2010, 21:37
mattlf mattlf is offline
Junior Member
 
Join Date: Feb 2010
Posts: 8
Default

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
Reply With Quote
  #6  
Old 05-02-2010, 21:40
mrmurdock mrmurdock is offline
Member
 
Join Date: Aug 2009
Posts: 70
Default

Go to www.mysql.com and do a search for Mysql 5.0 Manual...
thats about as much as I can do.
Reply With Quote
  #7  
Old 05-02-2010, 22:20
richlv richlv is offline
Administrator
Zabbix Certified Specialist
 
Join Date: Oct 2005
Posts: 2,981
Default

update zabbix.users set passwd=md5('mynewpassword') where alias='Admin';
Reply With Quote
  #8  
Old 05-02-2010, 22:31
mattlf mattlf is offline
Junior Member
 
Join Date: Feb 2010
Posts: 8
Default

cool. it works. Thanks a lot
I had to restart the web server as well
Reply With Quote
  #9  
Old 01-04-2010, 16:19
chocho63 chocho63 is offline
Member
 
Join Date: Jun 2005
Location: France
Posts: 52
Default 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...
Reply With Quote
  #10  
Old 14-10-2011, 21:38
aic aic is offline
Member
 
Join Date: Oct 2010
Posts: 50
Default

Hi All,

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

Thanks!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 00:10.