安装zabbix初始化mysql

# 更新包列表
sudo apt-get update

# 安装MySQL服务器
sudo apt-get install mysql-server

# 启动MySQL服务
sudo systemctl start mysql

# 设置MySQL开机自启动
sudo systemctl enable mysql

# 运行MySQL安全安装脚本
sudo mysql_secure_installation

# 安装Zabbix服务器和前端
sudo apt-get install zabbix-server-mysql zabbix-frontend-php

# 安装Zabbix Agent
sudo apt-get install zabbix-agent

# 登录MySQL
sudo mysql -u root -p

# 创建Zabbix数据库
mysql> CREATE DATABASE zabbix CHARACTER SET utf8 COLLATE utf8_bin;

# 授予Zabbix用户权限
mysql> GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'localhost' IDENTIFIED BY 'password';

# 刷新权限
mysql> FLUSH PRIVILEGES;

# 退出MySQL
mysql> EXIT;

# 导入Zabbix数据库结构
sudo zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | sudo mysql -uzabbix -p zabbix

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

# 启动Zabbix服务器
sudo systemctl start zabbix-server

# 设置Zabbix服务器开机自启动
sudo systemctl enable zabbix-server

# 启动Zabbix Agent
sudo systemctl start zabbix-agent

# 设置Zabbix Agent开机自启动
sudo systemctl enable zabbix-agent