How to set up an open fire server with mysql database
Table of contents
No headings in the article.
in this tutorial am going to teach you how to install open fire server with MySQL database, am going to configure MySQL to work with open fire setup. this how to video will eliminate every possible stress, open fire is used to create a chat server for chat applications.
Applications Openfire 4.7.3,Mysql server 8.0.28,Spark 2.9.4 Today am going to show you how to set up an openfire server with mysql database
1.Create database using mysql workbench 2.export the database 3.install openfire 4.import the mysql database
Create New Schema
Schema name openfire then apply
Apply
Finish
Go to server -->data export
Export self contained file
Export desktop with file name openfire
Start export
Paste the openfire.sql file C:\Program Files\Openfire\resources\database
Open fire as run as administrator
Continue
Continue
Standard Database Connection
Database driver mysql,hostname localhost,databasename openfire,username root,password what you give
Default
Skip the step,username admin,password admin
Login to the admin console
username admin,password admin
Login sucess
Open spark username admin,password admin,domain hostname as you given
Login sucess
