Meaningless Drivel is fun!
The moose likes JForum and the fly likes Setting up MySQL for JForum Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "Setting up MySQL for JForum" Watch "Setting up MySQL for JForum" New topic

Setting up MySQL for JForum

Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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 (

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 by brainofp]
Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Thanks for sharing this!! The best place would be the documentation, at

[originally posted on by Rafael Steil]
Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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 by luorihui]
I agree. Here's the link:
subject: Setting up MySQL for JForum
It's not a secret anymore!