Ad Widget

Collapse

Zabbix 1.8.1 Gui does not connect since adding DB Password

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mrmurdock
    Member
    • Aug 2009
    • 85

    #1

    Zabbix 1.8.1 Gui does not connect since adding DB Password

    I added a password to my mysql zabbix database
    mysqladmin -u root password '<password>'

    Now when I try to login as Admin. I get the following error.
    "mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied
    for user 'root'@'localhost' (using password: NO)[/home/zabbix/public_html/include/db.inc.php:58]"

    I have tried to copy over the 1.8 db.inc.php file but no change.
    the /etc/zabbix/zabbix_server.conf file does have the password in it, and the server and agent are running.
    I can connect from the command line.
    mysql -u root -p zabbix
    password:<password>
    mysql>
  • mrmurdock
    Member
    • Aug 2009
    • 85

    #2
    Thank goodness the Export/import feature doesnt work. I will have to reload os and everything from DVD media.

    Comment

    • nelsonab
      Senior Member
      Zabbix Certified SpecialistZabbix Certified Professional
      • Sep 2006
      • 1233

      #3
      ??

      reload everything?

      Edit the zabbix php config file and put the DB password in there. The file is zabbix.conf.php and is found in the conf directory in your Zabbix gui. The line that says "$DB["PASSWORD"]" is the one you want to edit...
      RHCE, author of zbxapi
      Ansible, the missing piece (Zabconf 2017): https://www.youtube.com/watch?v=R5T9NidjjDE
      Zabbix and SNMP on Linux (Zabconf 2015): https://www.youtube.com/watch?v=98PEHpLFVHM

      Comment

      Working...