Zabbix Server Isnt Running

[dorianus1992]

Hey,

Im a new to Zabbix, just managed to install everything and login to the Dashboard where i noticed that Zabbix server isnt running.

[root@zabbix zabbix]# tail -5 /var/log/zabbix/zabbix_server.log
2411:20200524:151344.449 database is down: reconnecting in 10 seconds
2411:20200524:151354.449 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO)
2411:20200524:151354.449 database is down: reconnecting in 10 seconds
2411:20200524:151404.450 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO)
2411:20200524:151404.450 database is down: reconnecting in 10 seconds

Im able to login the mysql
by using

[B]mysql -u root -p[/B]

and granted privileges "grant all privileges on zabbix.* to zabbix@localhost;"

This is the zabbix.conf.php configuration file
I tried both localhost and the server ip address- nothing worked

?php
// Zabbix GUI configuration file.

$DB['TYPE'] = 'MYSQL';
$DB['SERVER'] = 'My server IP';
$DB['PORT'] = '0';
$DB['DATABASE'] = 'zabbix';
$DB['USER'] = 'zabbix';
$DB['PASSWORD'] = 'Password';

// Schema name. Used for PostgreSQL.
$DB['SCHEMA'] = '';

// Used for TLS connection.
$DB['ENCRYPTION'] = false;
$DB['KEY_FILE'] = '';
$DB['CERT_FILE'] = '';
$DB['CA_FILE'] = '';
$DB['VERIFY_HOST'] = false;
$DB['CIPHER_LIST'] = '';

// Use IEEE754 compatible value range for 64-bit Numeric (float) history values.
// This option is enabled by default for new Zabbix installations.
// For upgraded installations, please read database upgrade notes before enabling this option.
$DB['DOUBLE_IEEE754'] = true;

$ZBX_SERVER = 'My server IP';
$ZBX_SERVER_PORT = '10051';
$ZBX_SERVER_NAME = 'zabbix';

$IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;

// Uncomment this block only if you are using Elasticsearch.
// Elasticsearch url (can be string if same url is used for all types).
//$HISTORY['url'] = [
// 'uint' => 'http://localhost:9200',
// 'text' => 'http://localhost:9200'
//];
// Value types stored in Elasticsearch.
//$HISTORY['types'] = ['uint', 'text'];

// Used for SAML authentication.
// Uncomment to override the default paths to SP private key, SP and IdP X.509 certificates, and to set extra settings.
//$SSO['SP_KEY'] = 'conf/certs/sp.key';
//$SSO['SP_CERT'] = 'conf/certs/sp.crt';
//$SSO['IDP_CERT'] = 'conf/certs/idp.crt';
//$SSO['SETTINGS'] = [];

Firewall is Disable and sudo setenforce 0.

I have searched the resulotion for this issue all over the forum and nothing helped.

Please HELP!

[Atsushi]

Did you set the connection information to the database in the Zabbix server configuration file(/etc/zabbix/zabbix_server.conf)?