How to install openfire chat server on centos7/redhat7 with mysql database

How to install openfire chat server on centos7/redhat7 with mysql database and installation spark on windows client. and create user
on openfire.

install openfire chat server
yum update -y
openfire download link----https://www.igniterealtime.org/downlo...
yum install *.rpm
systemctl start openfire.service
systemctl enable openfire.service
systemctl stop firewalld
systemctl disable firewalld

install mysql server

yum install mariadb-server
systemctl start mariadb.service
systemctl enanle mariadb.service
/usr/bin/mysql_secure_installation
mysql -u root -P
CREATE DATABASE openfire ;
CREATE USER 'openfire'@'spark' IDENDIFIED BY '123456';
GRANT ALL PRIVILEGES ON openfire.* TO 'openfire'@'spark';
FLUSH PRIVILEGES;
QUIT



learn linux guide