connection to database zabbix failed:(zabbix连接不上数据库的解决方法)

首先确认防火墙关闭

[zhang@Hadoop177 ~]$ cp /usr/share/doc/zabbix-server-mysql*/create.sql.gz .

[zhang@Hadoop177 ~]$ gunzip create.sql.gz

[zhang@Hadoop177 ~]$ sed -ir ‘1 iSET SESSION innodb_strict_mode=OFF;’ create.sql

在MySQL里面进行操作

mysql> create database if not exists zabbix character set utf8 collate utf8_bin;
mysql> set global validate_password_length=4;
mysql> set global validate_password_policy=0;
mysql> grant all on zabbix.* to zabbix@localhost identified by '1234';
mysql> flush privileges;

然后输入以下命令输入刚刚设置好的密码就好了

[zhang@Hadoop177 ~]$ cat create.sql | mysql -uzabbix zabbix -p mysql:

[Warning] World-writable config file ‘/etc/my.cnf’ is ignored. Enter
password:

就可以再次进行登录