Creating databases

Use the command line tool dboo to create users, databases and access groups.

Access to databases are controlled with users and groups. Each database and each user are assigned any number of access groups. Currently there is only full access or no access to a database. Users log in with a user id and password.

Setting the root password

With an empty server instance, there is one user already, the root user with an empty password. First step would be to set the root user’s password to something else.

The following example shows dboo in interactive mode. It shows how to connect to the server database as root and set the root password.

The interactive mode has auto completion of commands. Use the tab key to expand a partly written command or argument to either complete the command or see a list of potential completions.

> dboo
dboo> connect -u=root -p=
dboo root@dboo::server> set password
Old password:
New password: ***
Repeat password: ***
User 'root' was updated.
dboo root@dboo::server>

Create a user

Create users while connected as a root user (any user can become a root user by being assigned to the root group). With create user and create database, any non existing groups entered with the –groups option will be automatically created.

> dboo
dboo> connect -u=root -p=MyPassword
dboo root@dboo::server> create user <press tab here, shows completions>
<user_id>       options:       --password     --groups       --description
dboo root@dboo::server> create user MyNewUser --password=UserPwd --groups=AGroup
Created user 'MyNewUser'
dboo root@dboo::server>

Create a database

Create databases while connected as a root user.

> dboo
dboo> connect -u=root -p
Logging in as root to dboo::server on localhost:8822.
password: ***
dboo root@dboo::server> create database MyNewDatabase --groups=AGroup
Created database 'MyNewDatabase'
dboo root@dboo::server>