Error message

[ksm451]

After upgrading using mysql patches,this is the error message that comes up whiles trying to connect.

Error connecting to database [Access denied for user: '@localhost' to database 'zabbix']

[johnl]

in your file include/db.inc.php for zabbix have you configured the following

// $DB_TYPE ="POSTGRESQL";
$DB_TYPE ="MYSQL";
$DB_SERVER ="localhost";
$DB_DATABASE ="<whateverdatabase>";
$DB_USER ="<whateverdbuser>";
$DB_PASSWORD ="<whateverpassword>";

this needs to be configured so php can connect to mysql database. also check that your zabbix user can login to zabbix database locally on mysql server using

mysql -u zabbix zabbix -p

[Nate Bell]

Also, make sure your MySQL Grant tables are configured properly to allow '@localhost' to access the database.

[ksm451]

Thanks for your help,but am not an expert in database so i really dont know how it works,but after inssuing the command :
# mysql -u zabbix zabbix -p and enter i get this error below

ERROR 1044: Access denied for user: '@localhost' to database 'zabbix'

[ksm451]

root@ns2:/etc/mysql # mysql -u zabbix -p
but with the above, am able to log into the mysql database