Linux serverNETWORK ADMINISTRATIONS

Zabbix 7.0 installation with MySQL Database 8.0.35 | MySQL Database error 8.0.35 resolved for Zabbix

database error repo
rpm –import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

database installation steps

1) Download and add mysql yum repository to Linux repository.

sudo wget https://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm

2) Install the downloaded package, type “Y” on the prompt to continue.

sudo yum install mysql80-community-release-el7-1.noarch.rpm

3) To know the downloaded “Repolist” on the CentOS 8 machine issue the below command.

sudo yum repolist enabled | grep “mysql.*-community.*”

4) If MySQL client is already installed, before we install MySQL 8.0, issue the following command to disable mysql module. Without disabling this module installation of MySQL 8.0 server may fail. Type “Y” to continue.

sudo yum module disable mysql

5) Install the MySQL server 8.0 by issuing the below command

sudo yum -y install mysql-community-server

6) Start the MySQL server and enable services to run automatically when Linux machine is restarted.

sudo service mysqld start

sudo systemctl enable mysqld

7) To know the status of the MySQL server issue the below command.

sudo systemctl status mysqld

When MySQL 8.0 is installed, temporary root password for MySQL is created under /var/log/mysqldlog. You need to get the password using the following command.

sudo grep ‘temporary password’ /var/log/mysqld.log
T,W_4e6lhTZ?
Password@123

sudo mysql_secure_installation

Install and configure Zabbix for your platform
Install Zabbix repository
install Zabbix server
Install latest Zabbix-server 7.0
install Zabbix 7.0 with MySQL database 8.0.35
Zabbix server is not running.
Zabbix server is not compatible with MySQL database.

#zabbix #zabbix-server #zabbix latest #zabbix 7.0 #mysql #mysql 8.0.35 #centos #centos7 #centos8 #linux #linux_tutorial

source

centos 7