Error connecting to database: Access denied for user ‘zabbix‘@‘locahost‘

遇见问题:
Error connecting to database: Access denied for user ‘zabbix’@‘locahost’

分析问题:
数据库配置文件不正确

解决问题:

第一历程:检查zabbix主配置文件的数据库连接是否正确
grep -Ev “^$|#” /etc/zabbix/zabbix_server.conf

DBHost=localhost
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix

第二历程:检查数据库迁移的文件是否改动
DBHost $DB[‘SERVER’] 这两个名称需要保持一致!!!

vim /etc/zabbix/web/zabbix.conf.php

<?php
// Zabbix GUI configuration file.
global $DB;

$DB['TYPE']     = 'MYSQL';
$DB['SERVER']   = 'localhost';
$DB['PORT']     = '0';
$DB['DATABASE'] = 'zabbix';
$DB['USER']     = 'zabbix';
$DB['PASSWORD'] = 'zabbix';

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

$ZBX_SERVER      = 'localhost';
$ZBX_SERVER_PORT = '10051';

更多精彩内容，请关注微信公众号获取