MySQL password problem

[befortin]

Hi,

I have changed my MySQL root password. Now I get errors, so I went in the db.inc.php to change the password in the config. My new config is now :

// DATABASE CONFIGURATION
$DB_TYPE ="MYSQL";
$DB_SERVER ="localhost";
$DB_DATABASE ="zabbix";
$DB_USER ="root";
$DB_PASSWORD ="mypassword";
// END OF DATABASE CONFIGURATION

I still can't get Zabbix to work. I get the following error when starting the zabbix server :

"Starting zabbix_server Failed to connect to database: Error: Access denied for user 'root'@'localhost' (using password: YES)"

I'm 100% sure that the password in the db.inc.php file is the good one (I have tried it several times.

[Nate Bell]

Are you certain you changed the password for 'root'@'localhost'? Run mysql mysql and do a select * from user;. Check through the rows and make sure you have a row for | localhost | root |. You may have changed the password to 'root'@'whateveryourhostnameis' , or 'root'@'%' instead of localhost, and Zabbix connects with 'root'@'localhost'. If you have multiple entries for root, look at their encrypted passwords and make sure they match. If they don't, then you need to alter them to match your new password.

Nate

[elkor]

Isn't the password also stored in zabbix_server.conf?

I'm pretty sure that the username/password combo in db.inc.php is for use by the front end (as this technically does not have to be on the same machine that runs zabbix_server/zabbix_suckerd.

but then again, I could be wrong.. I don't have it in front of me.

[Nate Bell]

elkor, I checked, and you're right about the password also being in zabbix_server/suckerd.conf. I would give that a try before playing around with the MySQL database.

Nate

[James Wells]

Greetings,

The password is in zabbix_server.conf, zabbix_sucker.conf, zabbix_trapper.conf, and db.inc.php.

zabbix_server.conf and zabbix_sucker.conf are the main zabbix server configuration files, with zabbix_server.conf indicating a zabbix 1.1 server and zabbix_sucker.conf indicating a pre-1.1 server.

zabbix_trapper.conf is the main configuration file for the zabbix trapper system.

Finally, db.inc.php is the main configuration file for the DB portion of the zabbix frontend.