Version 2 (modified by varun, 9 years ago)

--

Setting up ORCA database environment

NOTE: these instructions help set up an initial database environment for emulation mode. Extensions to these procedures for real substrate are discussed elsewhere.

1. Create user 'orca' in mysql and grant it all privileges on database 'orca':

$ mysql -u root
mysql> grant all privileges on orca.* to orca;
mysql> grant all privileges on orca.* to orca@localhost;
mysql> flush privileges;

2. Create a database called 'orca'

mysql> create database orca;

3. Populate the database with initial inventory

$ mysql -u orca <~/orca/core/schema/mysql/full.schema.sql
$ mysql -u orca <~/orca/core/schema/mysql/full.data.sql
$ mysql -u orca <~/orca/tools/cmdline/renci/demo2.inventory.sql