Enter current password for root (enter for none): OK, successfully used password, moving on... Set root password? [Y/n] y Remove anonymous users? [Y/n] y Disallow root login remotely? [Y/n] n Remove test database and access to it? [Y/n] y Reload privilege tables now? [Y/n] y
################# mysql -uroot -p1234 #成功登录
添加数据库用户，以及zabbix所需的数据库信息
1 2 3 4
create database zabbix character set utf8 collate utf8_bin; # 创建数据库 create user zabbix@localhost identified by '1234'; # 创建用户 grant all privileges on zabbix.* to zabbix@localhost; # 授权zabbix数据库下的所有表给zabbix这个用户 flush privileges; # 刷新
使用zabbix-mysql命令导入数据库信息
1 2 3 4 5 6 7 8 9
ls /usr/share/doc/zabbix-server-mysql*/create.sql.gz # 先查看以下 /usr/share/doc/zabbix-server-mysql-5.0.22/create.sql.gz ## mysql -u用户名 -p 数据库名 zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbix
mysql -uzabbix -p1234 # 登录查看 show databases; use zabbix; show tables; # 可以查看很多表
修改zabbix server配置文件，修改数据库密码
1 2 3 4 5 6 7 8 9 10
vi /etc/zabbix/zabbix_server.conf ### Option: DBPassword # Database password. # Comment this line if no password is used. # # Mandatory: no # Default: DBPassword=1234 ################ grep '^DBPass' /etc/zabbix/zabbix_server.conf # 查看是否修改成功
修改php配置文件
1 2
vi /etc/opt/rh/rh-php72/php-fpm.d/zabbix.conf php_value[date.timezone] = Asia/Shanghai # 修改时区，取消注释
sudo apt install zabbix-proxy-mysql zabbix-get -y # get可能安装不上，就不安装了 apt-get install mariadb-server python-pymysql service mysql restart vi /etc/mysql/my.cnf [mysqld] collation-server = utf8_unicode_ci init-connect='SET NAMES utf8' character-set-server = utf8
mysql_secure_installation # 加强MariaDB的安全设置： create database zabbix_proxy character set utf8 collate utf8_bin; create user zabbix@localhost identified by '1234'; grant all privileges on zabbix_proxy.* to zabbix@localhost; # 授权zabbix数据库下的所有表给zabbix这个用户 grant all on zabbix_proxy.* to 'zabbix'@'localhost' identified by 'zabbix' with grant option; # 如果报错用该命令 flush privileges; # 刷新
# 修改配置文件 vi /etc/zabbix/zabbix_proxy.conf sed -i.ori '162a DBPassword=zabbix' /etc/zabbix/zabbix_proxy.conf # 修改162行,并做了.ori的备份文件 sed -i 's#Server=127.0.0.1#Server=119.255.249.177#' /etc/zabbix/zabbix_proxy.conf sed -i 's#Hostname=Zabbix proxy#Hostname=ryu#' /etc/zabbix/zabbix_proxy.conf
## 添加数据库用户，以及 zabbix 所需的数据库信息 mysql -u root -p CREATE DATABASE zabbix_proxy character set utf8 collate utf8_bin; create user zabbix@localhost identified by '1234'; grant all privileges on zabbix_proxy.* to zabbix@localhost; flush privileges;
# 3. 初始化 数据库 # mysql -uroot -p password mysql> create database zabbix character set utf8 collate utf8_bin; mysql> create user zabbix@localhost identified by 'Ghxw_0603'; mysql> grant all privileges on zabbix.* to zabbix@localhost grant all privileges on zabbix.* to'zabbix'@'%' identified by 'Ghxw_0603'; mysql> quit;
zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbix
ls /usr/share/doc/zabbix-server-mysql*/create.sql.gz # 先查看以下 /usr/share/doc/zabbix-server-mysql-5.0.22/create.sql.gz ## mysql -u用户名 -p 数据库名
