2,411
edits
Changes
Jump to navigation
Jump to search
mLine 30:
Line 30: − − − − − IMPORTANT: You may wish to alter the "openfireuser" and "yourpassword" information in the grant privileges line above. BE SURE TO REMEMBER WHAT YOU USED AS THE WEB MANAGER WILL ASK YOU FOR IT!+
Added Template:Warning box and some minor layout fixes
mysqladmin create openfiredb
mysqladmin create openfiredb
mysql -e "grant all privileges on openfiredb.* to openfireuser@localhost identified by 'yourpassword'"
mysql -e "grant all privileges on openfiredb.* to openfireuser@localhost identified by 'yourpassword'"
mysql -e "flush privileges"
mysql -e "flush privileges"
cd /opt/openfire/resources/database
cd /opt/openfire/resources/database
mysql openfiredb < openfire_mysql.sql
mysql openfiredb < openfire_mysql.sql
{{Warning box|You may wish to alter the "openfireuser" and "yourpassword" information in the grant privileges line above. Be sure to remember to remember what you used as the web manager will ask you for it!}}
== Access MySQL from the local network ==
== Access MySQL from the local network ==