• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Setting up MySQL for JForum

 
Migrated From Jforum.net
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]
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic