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.
|