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