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