zabbix new installation issue with mysql

[kaisim]

hello masters,

i've just installed zabbix according to the guide:https://www.zabbix.com/download

i have completed:
a. Install Zabbix repository

# rpm -Uvh https://repo.zabbix.com/zabbix/4.4/r...el8.noarch.rpm
# dnf clean all

b. Install Zabbix server, frontend, agent

# dnf -y install zabbix-server-mysql zabbix-web-mysql zabbix-apache-conf zabbix-agent


however, when i start with the next step, mysql seems not working. i dont know why, would anyone please help me take a look?


c. Create initial database

# mysql -uroot -p
password
mysql> create database zabbix character set utf8 collate utf8_bin;
mysql> grant all privileges on zabbix.* to zabbix@localhost identified by 'password';
mysql> quit;


when i tried to input above, it comes this to my terminal:

[root@localhost wang]# mysql -uroot -p
bash: mysql: command not found...
Failed to search for file: Cannot update read-only repo

[root@localhost wang]# whereis mysql
mysql: /usr/lib64/mysql /usr/share/mysql

[kloczek]

[root@localhost wang]# whereis mysql
mysql: /usr/lib64/mysql /usr/share/mysql

"whereis" command shows you entry from (s)locate database. If you need to locate command on $PATH you need to use "which" command.
In this case you need to execute "dnf install /usr/bin/mysql".

PS. Your issue has nothing to do with zabbix.

[kaisim]

should i install mysql again by the command below?


[root@localhost wang]# dnf install /usr/bin/mysql
Last metadata expiration check: 0:27:56 ago on Fri 18 Oct 2019 06:55:25 PM CST.
Dependencies resolved.
================================================== ================================================== =======================
Package Arch Version Repository Size
================================================== ================================================== =======================
Installing:
mariadb x86_64 3:10.3.11-2.module_el8.0.0+35+6f2527ed AppStream 6.2 M
Installing dependencies:
mariadb-common x86_64 3:10.3.11-2.module_el8.0.0+35+6f2527ed AppStream 62 k
mariadb-connector-c x86_64 3.0.7-1.el8 AppStream 148 k
Enabling module streams:
mariadb 10.3

Transaction Summary
================================================== ================================================== =======================
Install 3 Packages

Total download size: 6.4 M
Installed size: 39 M
Is this ok [y/N]: n

[acatic1]

You are right, not a zabbix issue, but rather a zabbix documentation issue. Following the instructions at https://www.zabbix.com/download?zabb...ysql&ws=apache would make a normal person think that it takes care of mysql installation.

[IntuitiveNZ]

@acatic1: Yes, it's a documentation issue - and quite a major one!

[gofree]

something is wrong with your mysql installation

yum install mysql-server

try

systemctl start mysqld
systemctl status mysqld

ps -ef | grep mysql

https://tecadmin.net/install-mysql-8-on-centos/

[ZaBeast]

You are using CentOS 8, install MariaDB:
dnf -y install mariadb-server && systemctl start mariadb && systemctl enable mariadb

You can find out more in this step-by-step guide:

https://bestmonitoringtools.com/how-to-install-zabbix-server-on-centos-or-rhel/

[kaisim]

it is working perfectly, thank you man!