• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Setting up MySQL for JForum

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
While installing JForum with MySQL i realized that there was some work to be done on the database to use it with JForum. Here are a few steps i found on the Net (https://wwwcgi.cdf.utoronto.ca/~cs494hf/cgi-bin/argon.cgi/helpphone/wiki/JForumSetup)

This step is only necessary if you will choose not to use JForum's built-in embedded database, HSQLDB. Furthermore, you should be able to perform this step with another database system such as PostgreSQL.

1. Download and install MySQL from the MySQL website or through the appropriate package for your system. Perform any necessary configuration.

2. Connect to your database server. E.g.,

$ mysql -u root -p

(You will be prompted for the database root password before you can proceed.)

3. Create and select a database named jforum:

mysql> create database jforum;
mysql> use jforum

4. Create a user for the jforum database with full privileges. This is what JForum will use.

mysql> grant all privileges on jforum.* to 'jforum-user'@'localhost' identified by 'jf0rum' with grant option;

You can substitute the above username and password with others to your liking.

5. We're done here, so you can quit.

mysql> quit

Please make a note of the following information for setting up JForum; the values used in the steps above are placed in parentheses:

* database name (jforum)
* database user (jforum-user)
* database user password (jf0rum)


[originally posted on jforum.net by brainofp]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for sharing this!! The best place would be the documentation, at http://www.jforum.net/confluence

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Great instruction except one addtion that if you're deal with non-ascii (chinese, japanese) locales, be sure to use utf8 for db encoding by

create database jforum charset=utf8;
[originally posted on jforum.net by luorihui]
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!