Skip to content

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
1
2
CREATE database bioreg;
CREATE USER 'username'@'<YOUR_HOSTNAME>' IDENTIFIED BY 'password';

Then grant the user privileges for tables: 

1
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX ON bioreg.* TO 'username'@'<YOUR_HOSTNAME>';
  • **Oracle example **
1
create user <USERNAME> identified by <PASSWORD> default tablespace <TABLESPACE_NAME> quota unlimited on <TABLESPACE_NAME>;

Grant the user privileges: 

1
2
3
4
grant connect to <USERNAME>;
grant create table to <USERNAME>;
grant create sequence to <USERNAME>;
grant resource to <USERNAME>;