Metadatabase configuration

In this step, need to connect on database system using database provider provided client tool. In this manual database setup steps are based on MySQL, Oracle.

Mysql Database Configuration Steps
Oracle Database Configuration Steps

MySQL Database Configuration Steps

Open MySQL command prompt and execute following command to connect to database system.

Proceed following process with MySQL command prompt or MySQL workbench.

  • Install and Start MySQL database

    On Linux machine, run the following command to install.

    apt-get install mysql-server
    sudo mysql_secure_installation utility

    On windows machine, download mysql server from the website and install.

    https://dev.mysql.com/downloads/installer/
  • Login as root user with the following command.

    mysql -uroot -hlocalhost -p
  • Create empty database with the following command on the above database command shell.
    CREATE DATABASE amplix_meta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE USER 'amplix'@'localhost' IDENTIFIED BY 'password';
  • Grant permission to database
    GRANT ALL PRIVILEGES ON amplix_meta.* TO 'amplix'@'localhost';
    FLUSH PRIVILEGES;
  • (Optional) Create Sample database user and database.
    CREATE DATABASE foodmeart;
    CREATE USER 'foodmart'@'localhost' IDENTIFIED BY 'password';
  • (Optional) Grant permission to foodmart user and database
    GRANT ALL PRIVILEGES ON foodmart.* TO 'amplix'@'localhost';
    GRANT ALL PRIVILEGES ON foodmart.* TO 'foodmart'@'localhost';
    FLUSH PRIVILEGES;

Oracle Database Configuration Steps

Proceed following process with sqlplus or SQL Developer session to connect on database system.

  • Login as system user with the following command.

    sqlplus system/password
  • Create new schema user.
    ALTER SESSION SET "_ORACLE_SCRIPT"=true;
    CREATE USER amplix IDENTIFIED BY password;
  • Grant permission to database
    ALTER USER amplix QUOTA UNLIMITED ON USERS;
    GRANT CREATE SESSION TO amplix;
    GRANT CREATE TABLE TO amplix;
    GRANT UNLIMITED TABLESPACE TO amplix;
  • (Optional) Create Sample database user and database.
    CREATE USER foodmart IDENTIFIED BY password;
  • (Optional) Grant permission to foodmart user and database
    ALTER USER foodmart QUOTA UNLIMITED ON USERS;
    GRANT CREATE SESSION TO foodmart;
    GRANT CREATE TABLE TO foodmart;
    GRANT UNLIMITED TABLESPACE TO foodmart;