Published: February, 15th 2008 HiveBoard
The online shared WhiteBoard
SourceForge.net Logo

2. Setup the HiveBoard database on MySQL

At this step, we suppose that the MySQL server is up and running, and that your path includes the MySQL tools directory.

You will first create the new HiveBoard database on your MySQL server:

cd hb-server-bin/initdb/mysql
mysql -u root -p <createdb-prod.sql
mysql -u root -D hiveboard -p <schema.sql
mysql -u root -D hiveboard -p <initdata-prod.sql

mysql will ask you the password of "root" before executing the command.

The file schema.sql creates the structure of the hiveboard database (tables, indexes). The file initdata-prod.sql creates one specific account (login='admin', empty password) who has HiveBoard administrator rights and can thus create other accounts (through the HiveBoard client application).

Before proceeding with the next step, let's check that the HiveBoard database has been correctly initialized:

mysql -u root -p
> use hiveboard
> select * from ACCOUNT;
> quit

mysql should display 'admin' in the list of accounts.