1. 导入 Zabbix Server 默认数据

在完成了数据库的创建后，可以导入默认的数据库数据
在命令行中输入如下代码，以导入默认数据：
zcat /usr/share/doc/zabbix-sql-scripts/mysql/create.sql.gz | mysql -uzabbix -p zabbix
失败
Welcome to Alibaba Cloud Elastic Compute Service !

Last login: Mon Feb 7 15:20:22 2022 from 118.31.243.238
[root@iZuf64ryrtt2km4w687n5cZ ~]# rpm -Uvh https://repo.zabbix.com/zabbix/5.4/rhel/8/x86_64/zabbix-release-5.4-1.el8.noarch.rpm
Retrieving https://repo.zabbix.com/zabbix/5.4/rhel/8/x86_64/zabbix-release-5.4-1.el8.noarch.rpm
warning: /var/tmp/rpm-tmp.COzPmY: Header V4 RSA/SHA512 Signature, key ID a14fe591: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:zabbix-release-5.4-1.el8 ################################# [100%]
[root@iZuf64ryrtt2km4w687n5cZ ~]# yum install zabbix-server-mysql zabbix-web-mysql zabbix-apache-conf zabbix-sql-scripts zabbix-agent -y
alinux3-module 4.3 MB/s | 417 kB 00:00
alinux3-updates 32 MB/s | 6.1 MB 00:00
alinux3-plus 34 MB/s | 4.6 MB 00:00
alinux3-powertools 16 MB/s | 1.6 MB 00:00
alinux3-os 37 MB/s | 5.8 MB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 66 MB/s | 11 MB 00:00
Zabbix Official Repository - x86_64 37 kB/s | 137 kB 00:03
Zabbix Official Repository non-supported - x86_64 933 B/s | 1.2 kB 00:01

Dependencies resolved.

Package Architecture Version Repository Size

Installing:
zabbix-agent x86_64 5.4.10-1.el8 zabbix 506 k
zabbix-apache-conf noarch 5.4.10-1.el8 zabbix 20 k
zabbix-server-mysql x86_64 5.4.10-1.el8 zabbix 1.4 M
zabbix-sql-scripts noarch 5.4.10-1.el8 zabbix 5.0 M
zabbix-web-mysql noarch 5.4.10-1.el8 zabbix 19 k
Installing dependencies:
OpenIPMI-libs x86_64 2.0.29-1.1.al8 alinux3-updates 513 k
alinux-logos-httpd noarch 82.0-1.1.al8 alinux3-updates 9.4 k
apr x86_64 1.6.3-11.1.al8 alinux3-os 125 k
apr-util x86_64 1.6.1-6.2.al8 alinux3-os 106 k
dejavu-fonts-common noarch 2.35-7.1.al8 alinux3-updates 74 k
dejavu-sans-fonts noarch 2.35-7.1.al8 alinux3-updates 1.5 M
fontconfig x86_64 2.13.1-3.2.al8 alinux3-os 278 k
fontpackages-filesystem noarch 1.44-22.1.al8 alinux3-os 16 k
fping x86_64 4.2-2.el8 epel 43 k
gd x86_64 2.2.5-7.1.al8 alinux3-os 144 k
httpd x86_64 2.4.37-39.1.al8.1 alinux3-updates 1.4 M
httpd-filesystem noarch 2.4.37-39.1.al8.1 alinux3-updates 39 k
httpd-tools x86_64 2.4.37-39.1.al8.1 alinux3-updates 105 k
jbigkit-libs x86_64 2.1-14.2.al8 alinux3-os 55 k
libX11 x86_64 1.6.8-4.1.al8 alinux3-updates 612 k
libX11-common noarch 1.6.8-4.1.al8 alinux3-updates 158 k
libXau x86_64 1.0.9-3.1.al8 alinux3-os 38 k
libXpm x86_64 3.5.12-8.1.al8 alinux3-os 58 k
libjpeg-turbo x86_64 1.5.3-10.2.al8 alinux3-os 156 k
libtiff x86_64 4.0.9-18.1.al8 alinux3-os 191 k
libwebp x86_64 1.0.0-3.1.al8 alinux3-updates 269 k
libxcb x86_64 1.13.1-1.3.al8 alinux3-os 230 k
libxslt x86_64 1.1.32-6.1.al8 alinux3-updates 250 k
mailcap noarch 2.1.48-3.1.al8 alinux3-os 39 k
mariadb-connector-c x86_64 3.1.11-2.1.al8 alinux3-updates 200 k
mariadb-connector-c-config noarch 3.1.11-2.1.al8 alinux3-updates 15 k
mod_http2 x86_64 1.15.7-3.1.al8 alinux3-updates 155 k
net-snmp-libs x86_64 1:5.8-20.1.al8 alinux3-updates 824 k
nginx-filesystem noarch 1:1.18.0-3.2.al8 alinux3-updates 25 k
oniguruma x86_64 6.8.2-2.1.al8 alinux3-os 187 k
php-bcmath x86_64 7.4.6-4.1.al8 alinux3-os 80 k
php-common x86_64 7.4.6-4.1.al8 alinux3-os 696 k
php-fpm x86_64 7.4.6-4.1.al8 alinux3-os 1.6 M
php-gd x86_64 7.4.6-4.1.al8 alinux3-os 85 k
php-json x86_64 7.4.6-4.1.al8 alinux3-os 74 k
php-ldap x86_64 7.4.6-4.1.al8 alinux3-os 85 k
php-mbstring x86_64 7.4.6-4.1.al8 alinux3-os 481 k
php-mysqlnd x86_64 7.4.6-4.1.al8 alinux3-os 192 k
php-pdo x86_64 7.4.6-4.1.al8 alinux3-os 123 k
php-xml x86_64 7.4.6-4.1.al8 alinux3-os 174 k
unixODBC x86_64 2.3.7-1.2.al8 alinux3-os 457 k
zabbix-web noarch 5.4.10-1.el8 zabbix 3.3 M
zabbix-web-deps noarch 5.4.10-1.el8 zabbix 20 k
Installing weak dependencies:
apr-util-bdb x86_64 1.6.1-6.2.al8 alinux3-os 25 k
apr-util-openssl x86_64 1.6.1-6.2.al8 alinux3-os 27 k

Transaction Summary

Install 50 Packages

Total download size: 22 M
Installed size: 83 M
Downloading Packages:
(1/50): dejavu-fonts-common-2.35-7.1.al8.noarch.rpm 2.5 MB/s | 74 kB 00:00
(2/50): alinux-logos-httpd-82.0-1.1.al8.noarch.rpm 188 kB/s | 9.4 kB 00:00
(3/50): dejavu-sans-fonts-2.35-7.1.al8.noarch.rpm 27 MB/s | 1.5 MB 00:00
(4/50): httpd-filesystem-2.4.37-39.1.al8.1.noarch.rpm 17 MB/s | 39 kB 00:00
(5/50): httpd-2.4.37-39.1.al8.1.x86_64.rpm 29 MB/s | 1.4 MB 00:00
(6/50): libX11-1.6.8-4.1.al8.x86_64.rpm 51 MB/s | 612 kB 00:00
(7/50): libX11-common-1.6.8-4.1.al8.noarch.rpm 9.9 MB/s | 158 kB 00:00
(8/50): OpenIPMI-libs-2.0.29-1.1.al8.x86_64.rpm 3.8 MB/s | 513 kB 00:00
(9/50): libxslt-1.1.32-6.1.al8.x86_64.rpm 31 MB/s | 250 kB 00:00
(10/50): httpd-tools-2.4.37-39.1.al8.1.x86_64.rpm 1.4 MB/s | 105 kB 00:00
(11/50): mariadb-connector-c-3.1.11-2.1.al8.x86_64.rpm 7.8 MB/s | 200 kB 00:00
(12/50): mod_http2-1.15.7-3.1.al8.x86_64.rpm 30 MB/s | 155 kB 00:00
(13/50): mariadb-connector-c-config-3.1.11-2.1.al8.noarch.rpm 1.1 MB/s | 15 kB 00:00
(14/50): libwebp-1.0.0-3.1.al8.x86_64.rpm 4.8 MB/s | 269 kB 00:00
(15/50): nginx-filesystem-1.18.0-3.2.al8.noarch.rpm 1.6 MB/s | 25 kB 00:00
(16/50): apr-util-1.6.1-6.2.al8.x86_64.rpm 34 MB/s | 106 kB 00:00
(17/50): apr-1.6.3-11.1.al8.x86_64.rpm 11 MB/s | 125 kB 00:00
(18/50): apr-util-openssl-1.6.1-6.2.al8.x86_64.rpm 2.2 MB/s | 27 kB 00:00
(19/50): fontconfig-2.13.1-3.2.al8.x86_64.rpm 47 MB/s | 278 kB 00:00
(20/50): fontpackages-filesystem-1.44-22.1.al8.noarch.rpm 8.0 MB/s | 16 kB 00:00
(21/50): net-snmp-libs-5.8-20.1.al8.x86_64.rpm 14 MB/s | 824 kB 00:00
(22/50): gd-2.2.5-7.1.al8.x86_64.rpm 4.7 MB/s | 144 kB 00:00
(23/50): libXau-1.0.9-3.1.al8.x86_64.rpm 3.3 MB/s | 38 kB 00:00
(24/50): apr-util-bdb-1.6.1-6.2.al8.x86_64.rpm 374 kB/s | 25 kB 00:00
(25/50): libjpeg-turbo-1.5.3-10.2.al8.x86_64.rpm 36 MB/s | 156 kB 00:00
(26/50): jbigkit-libs-2.1-14.2.al8.x86_64.rpm 1.4 MB/s | 55 kB 00:00
(27/50): libxcb-1.13.1-1.3.al8.x86_64.rpm 41 MB/s | 230 kB 00:00
(28/50): libtiff-4.0.9-18.1.al8.x86_64.rpm 13 MB/s | 191 kB 00:00
(29/50): oniguruma-6.8.2-2.1.al8.x86_64.rpm 45 MB/s | 187 kB 00:00
(30/50): mailcap-2.1.48-3.1.al8.noarch.rpm 3.1 MB/s | 39 kB 00:00
(31/50): php-bcmath-7.4.6-4.1.al8.x86_64.rpm 6.4 MB/s | 80 kB 00:00
(32/50): libXpm-3.5.12-8.1.al8.x86_64.rpm 1.0 MB/s | 58 kB 00:00
(33/50): php-gd-7.4.6-4.1.al8.x86_64.rpm 1.9 MB/s | 85 kB 00:00
(34/50): php-common-7.4.6-4.1.al8.x86_64.rpm 8.6 MB/s | 696 kB 00:00
(35/50): php-json-7.4.6-4.1.al8.x86_64.rpm 3.0 MB/s | 74 kB 00:00
(36/50): php-ldap-7.4.6-4.1.al8.x86_64.rpm 3.9 MB/s | 85 kB 00:00
(37/50): php-fpm-7.4.6-4.1.al8.x86_64.rpm 14 MB/s | 1.6 MB 00:00
(38/50): php-mysqlnd-7.4.6-4.1.al8.x86_64.rpm 8.4 MB/s | 192 kB 00:00
(39/50): php-mbstring-7.4.6-4.1.al8.x86_64.rpm 15 MB/s | 481 kB 00:00
(40/50): php-pdo-7.4.6-4.1.al8.x86_64.rpm 9.4 MB/s | 123 kB 00:00
(41/50): unixODBC-2.3.7-1.2.al8.x86_64.rpm 51 MB/s | 457 kB 00:00
(42/50): php-xml-7.4.6-4.1.al8.x86_64.rpm 9.7 MB/s | 174 kB 00:00
(43/50): fping-4.2-2.el8.x86_64.rpm 2.0 MB/s | 43 kB 00:00
(44/50): zabbix-apache-conf-5.4.10-1.el8.noarch.rpm 6.8 kB/s | 20 kB 00:03
(45/50): zabbix-agent-5.4.10-1.el8.x86_64.rpm 56 kB/s | 506 kB 00:09
(46/50): zabbix-web-5.4.10-1.el8.noarch.rpm 83 kB/s | 3.3 MB 00:39
(47/50): zabbix-web-deps-5.4.10-1.el8.noarch.rpm 70 kB/s | 20 kB 00:00
(48/50): zabbix-web-mysql-5.4.10-1.el8.noarch.rpm 61 kB/s | 19 kB 00:00
(49/50): zabbix-server-mysql-5.4.10-1.el8.x86_64.rpm 18 kB/s | 1.4 MB 01:22

(50/50): zabbix-sql-scripts-5.4.10-1.el8.noarch.rpm 17 kB/s | 5.0 MB 05:10

Total 72 kB/s | 22 MB 05:13
warning: /var/cache/dnf/zabbix-d3df1b2842222a01/packages/zabbix-agent-5.4.10-1.el8.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID a14fe591: NOKEY
Zabbix Official Repository - x86_64 1.6 MB/s | 1.7 kB 00:00
Importing GPG key 0xA14FE591:
Userid : "Zabbix LLC <packager@zabbix.com>"
Fingerprint: A184 8F53 52D0 22B9 471D 83D0 082A B56B A14F E591
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-ZABBIX-A14FE591
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : php-common-7.4.6-4.1.al8.x86_64 1/50
Installing : apr-1.6.3-11.1.al8.x86_64 2/50
Running scriptlet: apr-1.6.3-11.1.al8.x86_64 2/50
Installing : apr-util-bdb-1.6.1-6.2.al8.x86_64 3/50
Installing : apr-util-openssl-1.6.1-6.2.al8.x86_64 4/50
Installing : apr-util-1.6.1-6.2.al8.x86_64 5/50
Running scriptlet: apr-util-1.6.1-6.2.al8.x86_64 5/50
Installing : libjpeg-turbo-1.5.3-10.2.al8.x86_64 6/50
Installing : fontpackages-filesystem-1.44-22.1.al8.noarch 7/50
Running scriptlet: httpd-filesystem-2.4.37-39.1.al8.1.noarch 8/50
Installing : httpd-filesystem-2.4.37-39.1.al8.1.noarch 8/50
Installing : dejavu-fonts-common-2.35-7.1.al8.noarch 9/50
Installing : dejavu-sans-fonts-2.35-7.1.al8.noarch 10/50
Installing : zabbix-web-5.4.10-1.el8.noarch 11/50
Running scriptlet: zabbix-web-5.4.10-1.el8.noarch 11/50
Installing : fontconfig-2.13.1-3.2.al8.x86_64 12/50
Running scriptlet: fontconfig-2.13.1-3.2.al8.x86_64 12/50
Installing : httpd-tools-2.4.37-39.1.al8.1.x86_64 13/50
Installing : php-bcmath-7.4.6-4.1.al8.x86_64 14/50
Installing : php-json-7.4.6-4.1.al8.x86_64 15/50
Installing : php-ldap-7.4.6-4.1.al8.x86_64 16/50
Installing : php-pdo-7.4.6-4.1.al8.x86_64 17/50
Installing : php-mysqlnd-7.4.6-4.1.al8.x86_64 18/50
Installing : fping-4.2-2.el8.x86_64 19/50
Installing : unixODBC-2.3.7-1.2.al8.x86_64 20/50
Running scriptlet: unixODBC-2.3.7-1.2.al8.x86_64 20/50
Installing : oniguruma-6.8.2-2.1.al8.x86_64 21/50
Running scriptlet: oniguruma-6.8.2-2.1.al8.x86_64 21/50
Installing : php-mbstring-7.4.6-4.1.al8.x86_64 22/50
Installing : mailcap-2.1.48-3.1.al8.noarch 23/50
Installing : libXau-1.0.9-3.1.al8.x86_64 24/50
Installing : libxcb-1.13.1-1.3.al8.x86_64 25/50
Installing : jbigkit-libs-2.1-14.2.al8.x86_64 26/50
Running scriptlet: jbigkit-libs-2.1-14.2.al8.x86_64 26/50
Installing : libtiff-4.0.9-18.1.al8.x86_64 27/50
Running scriptlet: nginx-filesystem-1:1.18.0-3.2.al8.noarch 28/50
Installing : nginx-filesystem-1:1.18.0-3.2.al8.noarch 28/50
Installing : php-fpm-7.4.6-4.1.al8.x86_64 29/50
Running scriptlet: php-fpm-7.4.6-4.1.al8.x86_64 29/50
Installing : net-snmp-libs-1:5.8-20.1.al8.x86_64 30/50
Installing : mariadb-connector-c-config-3.1.11-2.1.al8.noarch 31/50
Installing : mariadb-connector-c-3.1.11-2.1.al8.x86_64 32/50
Installing : libxslt-1.1.32-6.1.al8.x86_64 33/50
Installing : php-xml-7.4.6-4.1.al8.x86_64 34/50
Installing : libwebp-1.0.0-3.1.al8.x86_64 35/50
Installing : libX11-common-1.6.8-4.1.al8.noarch 36/50
Installing : libX11-1.6.8-4.1.al8.x86_64 37/50
Installing : libXpm-3.5.12-8.1.al8.x86_64 38/50
Installing : gd-2.2.5-7.1.al8.x86_64 39/50
Running scriptlet: gd-2.2.5-7.1.al8.x86_64 39/50
Installing : php-gd-7.4.6-4.1.al8.x86_64 40/50
Installing : zabbix-web-deps-5.4.10-1.el8.noarch 41/50
Installing : zabbix-web-mysql-5.4.10-1.el8.noarch 42/50
Installing : alinux-logos-httpd-82.0-1.1.al8.noarch 43/50
Installing : mod_http2-1.15.7-3.1.al8.x86_64 44/50
Installing : httpd-2.4.37-39.1.al8.1.x86_64 45/50
Running scriptlet: httpd-2.4.37-39.1.al8.1.x86_64 45/50
Installing : OpenIPMI-libs-2.0.29-1.1.al8.x86_64 46/50
Running scriptlet: zabbix-server-mysql-5.4.10-1.el8.x86_64 47/50
Installing : zabbix-server-mysql-5.4.10-1.el8.x86_64 47/50
Running scriptlet: zabbix-server-mysql-5.4.10-1.el8.x86_64 47/50
Installing : zabbix-apache-conf-5.4.10-1.el8.noarch 48/50
Running scriptlet: zabbix-apache-conf-5.4.10-1.el8.noarch 48/50
Installing : zabbix-sql-scripts-5.4.10-1.el8.noarch 49/50
Running scriptlet: zabbix-agent-5.4.10-1.el8.x86_64 50/50
Installing : zabbix-agent-5.4.10-1.el8.x86_64 50/50
Running scriptlet: zabbix-agent-5.4.10-1.el8.x86_64 50/50
Running scriptlet: httpd-2.4.37-39.1.al8.1.x86_64 50/50
Running scriptlet: zabbix-agent-5.4.10-1.el8.x86_64 50/50
Running scriptlet: fontconfig-2.13.1-3.2.al8.x86_64 50/50
Running scriptlet: php-fpm-7.4.6-4.1.al8.x86_64 50/50
Verifying : OpenIPMI-libs-2.0.29-1.1.al8.x86_64 1/50
Verifying : alinux-logos-httpd-82.0-1.1.al8.noarch 2/50
Verifying : dejavu-fonts-common-2.35-7.1.al8.noarch 3/50
Verifying : dejavu-sans-fonts-2.35-7.1.al8.noarch 4/50
Verifying : httpd-2.4.37-39.1.al8.1.x86_64 5/50
Verifying : httpd-filesystem-2.4.37-39.1.al8.1.noarch 6/50
Verifying : httpd-tools-2.4.37-39.1.al8.1.x86_64 7/50
Verifying : libX11-1.6.8-4.1.al8.x86_64 8/50
Verifying : libX11-common-1.6.8-4.1.al8.noarch 9/50
Verifying : libwebp-1.0.0-3.1.al8.x86_64 10/50
Verifying : libxslt-1.1.32-6.1.al8.x86_64 11/50
Verifying : mariadb-connector-c-3.1.11-2.1.al8.x86_64 12/50
Verifying : mariadb-connector-c-config-3.1.11-2.1.al8.noarch 13/50
Verifying : mod_http2-1.15.7-3.1.al8.x86_64 14/50
Verifying : net-snmp-libs-1:5.8-20.1.al8.x86_64 15/50
Verifying : nginx-filesystem-1:1.18.0-3.2.al8.noarch 16/50
Verifying : apr-1.6.3-11.1.al8.x86_64 17/50
Verifying : apr-util-1.6.1-6.2.al8.x86_64 18/50
Verifying : apr-util-bdb-1.6.1-6.2.al8.x86_64 19/50
Verifying : apr-util-openssl-1.6.1-6.2.al8.x86_64 20/50
Verifying : fontconfig-2.13.1-3.2.al8.x86_64 21/50
Verifying : fontpackages-filesystem-1.44-22.1.al8.noarch 22/50
Verifying : gd-2.2.5-7.1.al8.x86_64 23/50
Verifying : jbigkit-libs-2.1-14.2.al8.x86_64 24/50
Verifying : libXau-1.0.9-3.1.al8.x86_64 25/50
Verifying : libXpm-3.5.12-8.1.al8.x86_64 26/50
Verifying : libjpeg-turbo-1.5.3-10.2.al8.x86_64 27/50
Verifying : libtiff-4.0.9-18.1.al8.x86_64 28/50
Verifying : libxcb-1.13.1-1.3.al8.x86_64 29/50
Verifying : mailcap-2.1.48-3.1.al8.noarch 30/50
Verifying : oniguruma-6.8.2-2.1.al8.x86_64 31/50
Verifying : php-bcmath-7.4.6-4.1.al8.x86_64 32/50
Verifying : php-common-7.4.6-4.1.al8.x86_64 33/50
Verifying : php-fpm-7.4.6-4.1.al8.x86_64 34/50
Verifying : php-gd-7.4.6-4.1.al8.x86_64 35/50
Verifying : php-json-7.4.6-4.1.al8.x86_64 36/50
Verifying : php-ldap-7.4.6-4.1.al8.x86_64 37/50
Verifying : php-mbstring-7.4.6-4.1.al8.x86_64 38/50
Verifying : php-mysqlnd-7.4.6-4.1.al8.x86_64 39/50
Verifying : php-pdo-7.4.6-4.1.al8.x86_64 40/50
Verifying : php-xml-7.4.6-4.1.al8.x86_64 41/50
Verifying : unixODBC-2.3.7-1.2.al8.x86_64 42/50
Verifying : fping-4.2-2.el8.x86_64 43/50
Verifying : zabbix-agent-5.4.10-1.el8.x86_64 44/50
Verifying : zabbix-apache-conf-5.4.10-1.el8.noarch 45/50
Verifying : zabbix-server-mysql-5.4.10-1.el8.x86_64 46/50
Verifying : zabbix-sql-scripts-5.4.10-1.el8.noarch 47/50
Verifying : zabbix-web-5.4.10-1.el8.noarch 48/50
Verifying : zabbix-web-deps-5.4.10-1.el8.noarch 49/50
Verifying : zabbix-web-mysql-5.4.10-1.el8.noarch 50/50

Installed:
OpenIPMI-libs-2.0.29-1.1.al8.x86_64 alinux-logos-httpd-82.0-1.1.al8.noarch
apr-1.6.3-11.1.al8.x86_64 apr-util-1.6.1-6.2.al8.x86_64
apr-util-bdb-1.6.1-6.2.al8.x86_64 apr-util-openssl-1.6.1-6.2.al8.x86_64
dejavu-fonts-common-2.35-7.1.al8.noarch dejavu-sans-fonts-2.35-7.1.al8.noarch
fontconfig-2.13.1-3.2.al8.x86_64 fontpackages-filesystem-1.44-22.1.al8.noarch
fping-4.2-2.el8.x86_64 gd-2.2.5-7.1.al8.x86_64
httpd-2.4.37-39.1.al8.1.x86_64 httpd-filesystem-2.4.37-39.1.al8.1.noarch
httpd-tools-2.4.37-39.1.al8.1.x86_64 jbigkit-libs-2.1-14.2.al8.x86_64
libX11-1.6.8-4.1.al8.x86_64 libX11-common-1.6.8-4.1.al8.noarch
libXau-1.0.9-3.1.al8.x86_64 libXpm-3.5.12-8.1.al8.x86_64
libjpeg-turbo-1.5.3-10.2.al8.x86_64 libtiff-4.0.9-18.1.al8.x86_64
libwebp-1.0.0-3.1.al8.x86_64 libxcb-1.13.1-1.3.al8.x86_64
libxslt-1.1.32-6.1.al8.x86_64 mailcap-2.1.48-3.1.al8.noarch
mariadb-connector-c-3.1.11-2.1.al8.x86_64 mariadb-connector-c-config-3.1.11-2.1.al8.noarch
mod_http2-1.15.7-3.1.al8.x86_64 net-snmp-libs-1:5.8-20.1.al8.x86_64
nginx-filesystem-1:1.18.0-3.2.al8.noarch oniguruma-6.8.2-2.1.al8.x86_64
php-bcmath-7.4.6-4.1.al8.x86_64 php-common-7.4.6-4.1.al8.x86_64
php-fpm-7.4.6-4.1.al8.x86_64 php-gd-7.4.6-4.1.al8.x86_64
php-json-7.4.6-4.1.al8.x86_64 php-ldap-7.4.6-4.1.al8.x86_64
php-mbstring-7.4.6-4.1.al8.x86_64 php-mysqlnd-7.4.6-4.1.al8.x86_64
php-pdo-7.4.6-4.1.al8.x86_64 php-xml-7.4.6-4.1.al8.x86_64
unixODBC-2.3.7-1.2.al8.x86_64 zabbix-agent-5.4.10-1.el8.x86_64
zabbix-apache-conf-5.4.10-1.el8.noarch zabbix-server-mysql-5.4.10-1.el8.x86_64
zabbix-sql-scripts-5.4.10-1.el8.noarch zabbix-web-5.4.10-1.el8.noarch
zabbix-web-deps-5.4.10-1.el8.noarch zabbix-web-mysql-5.4.10-1.el8.noarch

Complete!
[root@iZuf64ryrtt2km4w687n5cZ ~]# yum install -y mariadb-server
Last metadata expiration check: 0:05:56 ago on Mon 07 Feb 2022 03:20:58 PM CST.

Dependencies resolved.

Package Architecture Version Repository Size

Installing:
mariadb-server x86_64 3:10.5.9-1.1.al8 alinux3-updates 18 M
Upgrading:
selinux-policy noarch 3.14.3-80.0.1.al8.2 alinux3-updates 636 k
selinux-policy-targeted noarch 3.14.3-80.0.1.al8.2 alinux3-updates 15 M
Installing dependencies:
checkpolicy x86_64 2.9-1.2.al8 alinux3-os 348 k
libaio x86_64 0.3.112-1.2.al8 alinux3-os 33 k
mariadb x86_64 3:10.5.9-1.1.al8 alinux3-updates 6.2 M
mariadb-common x86_64 3:10.5.9-1.1.al8 alinux3-updates 67 k
mariadb-errmsg x86_64 3:10.5.9-1.1.al8 alinux3-updates 239 k
mysql-selinux noarch 1.0.2-4.1.al8 alinux3-updates 37 k
policycoreutils-python-utils noarch 2.9-9.1.al8 alinux3-os 251 k
python3-audit x86_64 3.0-0.17.20191104git1c2f876.1.al8 alinux3-os 86 k
python3-libsemanage x86_64 2.9-3.1.al8 alinux3-os 127 k
python3-policycoreutils noarch 2.9-9.1.al8 alinux3-os 2.2 M
python3-setools x86_64 4.3.0-2.1.al8 alinux3-os 650 k

Transaction Summary

Install 12 Packages
Upgrade 2 Packages

Total download size: 44 M
Downloading Packages:
(1/14): mariadb-common-10.5.9-1.1.al8.x86_64.rpm 1.4 MB/s | 67 kB 00:00
(2/14): mariadb-errmsg-10.5.9-1.1.al8.x86_64.rpm 3.9 MB/s | 239 kB 00:00
(3/14): mysql-selinux-1.0.2-4.1.al8.noarch.rpm 3.2 MB/s | 37 kB 00:00
(4/14): mariadb-server-10.5.9-1.1.al8.x86_64.rpm 87 MB/s | 18 MB 00:00
(5/14): checkpolicy-2.9-1.2.al8.x86_64.rpm 1.8 MB/s | 348 kB 00:00
(6/14): libaio-0.3.112-1.2.al8.x86_64.rpm 8.4 MB/s | 33 kB 00:00
(7/14): python3-audit-3.0-0.17.20191104git1c2f876.1.al8.x86_64.rpm 31 MB/s | 86 kB 00:00
(8/14): python3-libsemanage-2.9-3.1.al8.x86_64.rpm 42 MB/s | 127 kB 00:00
(9/14): python3-policycoreutils-2.9-9.1.al8.noarch.rpm 71 MB/s | 2.2 MB 00:00
(10/14): policycoreutils-python-utils-2.9-9.1.al8.noarch.rpm 5.7 MB/s | 251 kB 00:00
(11/14): python3-setools-4.3.0-2.1.al8.x86_64.rpm 60 MB/s | 650 kB 00:00
(12/14): mariadb-10.5.9-1.1.al8.x86_64.rpm 18 MB/s | 6.2 MB 00:00
(13/14): selinux-policy-3.14.3-80.0.1.al8.2.noarch.rpm 9.3 MB/s | 636 kB 00:00

(14/14): selinux-policy-targeted-3.14.3-80.0.1.al8.2.noarch.rpm 23 MB/s | 15 MB 00:00

Total 46 MB/s | 44 MB 00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : mariadb-common-3:10.5.9-1.1.al8.x86_64 1/16
Upgrading : selinux-policy-3.14.3-80.0.1.al8.2.noarch 2/16
Running scriptlet: selinux-policy-3.14.3-80.0.1.al8.2.noarch 2/16
Running scriptlet: selinux-policy-targeted-3.14.3-80.0.1.al8.2.noarch 3/16
Upgrading : selinux-policy-targeted-3.14.3-80.0.1.al8.2.noarch 3/16
Running scriptlet: selinux-policy-targeted-3.14.3-80.0.1.al8.2.noarch 3/16
Installing : mariadb-errmsg-3:10.5.9-1.1.al8.x86_64 4/16
Installing : python3-setools-4.3.0-2.1.al8.x86_64 5/16
Installing : python3-libsemanage-2.9-3.1.al8.x86_64 6/16
Installing : python3-audit-3.0-0.17.20191104git1c2f876.1.al8.x86_64 7/16
Installing : libaio-0.3.112-1.2.al8.x86_64 8/16
Installing : checkpolicy-2.9-1.2.al8.x86_64 9/16
Installing : python3-policycoreutils-2.9-9.1.al8.noarch 10/16
Installing : policycoreutils-python-utils-2.9-9.1.al8.noarch 11/16
Running scriptlet: mysql-selinux-1.0.2-4.1.al8.noarch 12/16
Installing : mysql-selinux-1.0.2-4.1.al8.noarch 12/16
Running scriptlet: mysql-selinux-1.0.2-4.1.al8.noarch 12/16
libsemanage.semanage_direct_install_info: Overriding mysql module at lower priority 100 with module at priority 200.

Running scriptlet: mariadb-server-3:10.5.9-1.1.al8.x86_64 13/16
Installing : mariadb-server-3:10.5.9-1.1.al8.x86_64 13/16
Running scriptlet: mariadb-server-3:10.5.9-1.1.al8.x86_64 13/16
Installing : mariadb-3:10.5.9-1.1.al8.x86_64 14/16
Cleanup : selinux-policy-targeted-3.14.3-54.1.al8.noarch 15/16
Running scriptlet: selinux-policy-targeted-3.14.3-54.1.al8.noarch 15/16
Cleanup : selinux-policy-3.14.3-54.1.al8.noarch 16/16
Running scriptlet: selinux-policy-3.14.3-54.1.al8.noarch 16/16
Running scriptlet: mysql-selinux-1.0.2-4.1.al8.noarch 16/16
Running scriptlet: selinux-policy-3.14.3-54.1.al8.noarch 16/16
Verifying : mariadb-3:10.5.9-1.1.al8.x86_64 1/16
Verifying : mariadb-common-3:10.5.9-1.1.al8.x86_64 2/16
Verifying : mariadb-errmsg-3:10.5.9-1.1.al8.x86_64 3/16
Verifying : mariadb-server-3:10.5.9-1.1.al8.x86_64 4/16
Verifying : mysql-selinux-1.0.2-4.1.al8.noarch 5/16
Verifying : checkpolicy-2.9-1.2.al8.x86_64 6/16
Verifying : libaio-0.3.112-1.2.al8.x86_64 7/16
Verifying : policycoreutils-python-utils-2.9-9.1.al8.noarch 8/16
Verifying : python3-audit-3.0-0.17.20191104git1c2f876.1.al8.x86_64 9/16
Verifying : python3-libsemanage-2.9-3.1.al8.x86_64 10/16
Verifying : python3-policycoreutils-2.9-9.1.al8.noarch 11/16
Verifying : python3-setools-4.3.0-2.1.al8.x86_64 12/16
Verifying : selinux-policy-3.14.3-80.0.1.al8.2.noarch 13/16
Verifying : selinux-policy-3.14.3-54.1.al8.noarch 14/16
Verifying : selinux-policy-targeted-3.14.3-80.0.1.al8.2.noarch 15/16
Verifying : selinux-policy-targeted-3.14.3-54.1.al8.noarch 16/16

Upgraded:
selinux-policy-3.14.3-80.0.1.al8.2.noarch selinux-policy-targeted-3.14.3-80.0.1.al8.2.noarch

Installed:
checkpolicy-2.9-1.2.al8.x86_64 libaio-0.3.112-1.2.al8.x86_64
mariadb-3:10.5.9-1.1.al8.x86_64 mariadb-common-3:10.5.9-1.1.al8.x86_64
mariadb-errmsg-3:10.5.9-1.1.al8.x86_64 mariadb-server-3:10.5.9-1.1.al8.x86_64
mysql-selinux-1.0.2-4.1.al8.noarch policycoreutils-python-utils-2.9-9.1.al8.noarch
python3-audit-3.0-0.17.20191104git1c2f876.1.al8.x86_64 python3-libsemanage-2.9-3.1.al8.x86_64
python3-policycoreutils-2.9-9.1.al8.noarch python3-setools-4.3.0-2.1.al8.x86_64

Complete!
[root@iZuf64ryrtt2km4w687n5cZ ~]# systemctl start mariadb
[root@iZuf64ryrtt2km4w687n5cZ ~]# systemctl enable mariadb
[root@iZuf64ryrtt2km4w687n5cZ ~]# systemctl start mariadb
[root@iZuf64ryrtt2km4w687n5cZ ~]# systemctl enable mariadb
[root@iZuf64ryrtt2km4w687n5cZ ~]# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB

  SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
haven't set the root password yet, you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password or using the unix_socket ensures that nobody
can log into the MariaDB root user without the proper authorisation.

You already have your root account protected, so you can safely answer 'n'.

Switch to unix_socket authentication [Y/n] y
Enabled successfully!
Reloading privilege tables..
... Success!

You already have your root account protected, so you can safely answer 'n'.

Change the root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!

By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] Y
... Success!

Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] Y
... Success!

By default, MariaDB comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] Y

• Dropping test database...

... Success!

• Removing privileges on test database...

... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] Y
... Success!

Cleaning up...

All done! If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!
[root@iZuf64ryrtt2km4w687n5cZ ~]# mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 13
Server version: 10.5.9-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database zabbix character set utf8 collate utf8_bin;
Query OK, 1 row affected (0.000 sec)

MariaDB [(none)]> create user zabbix@localhost identified by 'password';
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> grant all privileges on zabbix.* to zabbix@localhost;
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> quit;
Bye
[root@iZuf64ryrtt2km4w687n5cZ ~]# zcat /usr/share/doc/zabbix-sql-scripts/mysql/create.sql.gz | mysql -uzabbix -p zabbix
Enter password:
ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: YES)
[root@iZuf64ryrtt2km4w687n5cZ ~]# zcat /usr/share/doc/zabbix-sql-scripts/mysql/create.sql.gz | mysql -uzabbix -p zabbix
Enter password:
ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: YES)
[root@iZuf64ryrtt2km4w687n5cZ ~]# zcat /usr/share/doc/zabbix-sql-scripts/mysql/create.sql.gz | mysql -uzabbix -p zabbix
Enter password:
ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: YES)
[root@iZuf64ryrtt2km4w687n5cZ ~]# zcat /usr/share/doc/zabbix-sql-scripts/mysql/create.sql.gz | mysql -uzabbix -p zabbix
Enter password:
ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: YES)
[root@iZuf64ryrtt2km4w687n5cZ ~]# zcat /usr/share/doc/zabbix-sql-scripts/mysql/create.sql.gz | mysql -uzabbix -p zabbix
Enter password:
ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: YES)
[root@iZuf64ryrtt2km4w687n5cZ ~]# zcat /usr/share/doc/zabbix-sql-scripts/mysql/create.sql.gz | mysql -uzabbix -p zabbix
Enter password:
ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: YES)
[root@iZuf64ryrtt2km4w687n5cZ ~]# zcat /usr/share/doc/zabbix-sql-scripts/mysql/create.sql.gz | mysql -uzabbix -p zabbix
Enter password:
[root@iZuf64ryrtt2km4w687n5cZ ~]# systemctl restart zabbix-server zabbix-agent httpd php-fpm
[root@iZuf64ryrtt2km4w687n5cZ ~]#
[root@iZuf64ryrtt2km4w687n5cZ ~]# systemctl enable zabbix-server zabbix-agent httpd php-fpm
[root@iZuf64ryrtt2km4w687n5cZ ~]#