Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-15559

安装 zabbix3.4.15 Configure DB connection 提示:Cannot connect to the database Error setting auto commit.

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Critical
    • Resolution: Won't fix
    • 3.0.25
    • None
    • Installation (I)
    • None
    • 操作系统centos7 DB percon8

    Description

      1、安装mysql,使用percona8 修改配置项添加
      [client]
      default-character-set=utf8
      [mysql]
      default-character-set=utf8
      [mysqld]
      character-set-server=utf8
      collation-server=utf8_unicode_ci
      init_connect='SET AUTOCOMMIT=1'

      2、重启mysql
      systemctl restart mysqld.service
      3、创建zabbix数据库
      create database zabbix
      create user zabbix identified by 'xxxx';
      grant all privileges on zabbix.* to [email protected]'localhost';
      grant all privileges on zabbix.* to [email protected]'%';
      flush privileges;

      4、使用zabbix用户连接数据库检查autocommit
      提示 autocommit on

      4、启动zabbix
      systemctl start httpd.service
      5、访问zabbix进入配置安装界面
      http://192.168.1.xx/zabbix
      6、进行到Configure DB connection
       提示:Cannot connect to the database
      Error setting auto commit.

       

      Attachments

        Activity

          People

            zabbix.support Zabbix Support Team
            赵相明 byheart
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: