Database Setup for Biomolecule Toolkit

Biomolecule Toolkit requires an existing database schema to connect to and a corresponding user account in your database management system. You are free to choose any valid schema name and user credentials, these need to be reflected in the bioreg.properties file.

• MySQL example

CREATE database bioreg;
CREATE USER 'username'@'<YOUR_HOSTNAME>' IDENTIFIED BY 'password';

Then grant the user privileges for tables:

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX ON bioreg.* TO 'username'@'<YOUR_HOSTNAME>';

• Oracle example

create user <USERNAME> identified by <PASSWORD> default tablespace <TABLESPACE_NAME> quota unlimited on <TABLESPACE_NAME>;

Grant the user privileges:

grant connect to <USERNAME>;
grant create table to <USERNAME>;
grant create sequence to <USERNAME>;
grant resource to <USERNAME>;