#启动 Mariadb systemctl start mariadb #设为开机自启 systemctl enable mariadb #Mariadb 初始化 mysql -uroot use mysql grant all privileges on *.* to 'root'@'%' identified by '123456qwer'; # mysql rootzabbix为:123456qwer delete from mysql.user where User=''; FLUSH PRIVILEGES; # 重启数据库 systemctl restart mariadb
-- 创建用户 -- CREATE USER '用户名'@'localhost' IDENTIFIED BY '密码'; CREATEUSER'zabbix'@'localhost' IDENTIFIED BY'zabbix'; -- 创建数据库zabbix -- CREATE DATABASE `数据库名` CHARACTER SET utf8 COLLATE utf8_bin; CREATE DATABASE `zabbix` CHARACTER SET utf8 COLLATE utf8_bin; -- 赋予权限 -- grant all privileges on 数据库名.*to 用户名@'localhost' identified by '密码'; grantall privileges on zabbix.*to zabbix@'localhost' identified by'zabbix'; -- 刷新权限 flush privileges;
-- 设置编码 set names utf8; exit
-- 创建完导入zabbix 初始化数据 -- 如果databases下面的*.sql有缺失,可以重新解压 mysql -uzabbix -pzabbix zabbix </opt/zabbix-6.4.5/database/mysql/schema.sql -- 表结构 mysql -uzabbix -pzabbix zabbix </opt/zabbix-6.4.5/database/mysql/images.sql -- 图片相关数据 mysql -uzabbix -pzabbix zabbix </opt/zabbix-6.4.5/database/mysql/data.sql -- 模版相关数据