Posts tagged: Openfire on Trixbox | trixbox

How to Install Openfire on Trixbox

By , August 14, 2010 7:34 PM

make a DB in mysql
login to mysql
mysql -u root -p
then
CREATE DATABASE `openfire`;
CREATE USER ‘openfire’@’localhost’ IDENTIFIED BY ‘password’;
GRANT USAGE ON *.* TO ‘openfire’@’localhost’ IDENTIFIED BY ‘password’ WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON `openfire`.* TO ‘openfire’@’localhost’;
FLUSH PRIVILEGES;
quit

Thomas Challenger Thomas Challenger