Open topic with navigation
These instructions assume that you have installed the NuoDB software and chosen to automatically start the NuoDB services. If you have not started NuoDB services, it is necessary to do so manually. See Starting and Stopping NuoDB Services.
To create a single host database, sign in to the NuoDB Automation Console. On Windows, you can access the Automation Console from the NuoDB system tray.
Alternatively, you can enter an address such as
http:// in a browser, for example,
If you are not already signed in then the Automation Console prompts you to enter a domain username and password. If you specified a password during installation then specify that password here with the default username
domain. If you specified a password during installation but you have forgotten it then you can obtain the password from the
$NUODB_HOME/etc/default.properties file. The
domainPassword property specifies the password. If you already created an administrative user account then you can enter the username and password for that account. See Creating the First Domain Administrator Account.
A blank Automation Console opens. In the left panel, select Databases and then in the top right corner select Actions | Add Database, as shown below:
The Create Managed Database dialog appears:
Enter the database Name
test, DBA User
dba, and DBA Password
dba. Leave the defaults for everything else. Click Submit when finished. You now have a NuoDB database called
test running on your machine:
This NuoDB database includes one broker, one storage manager (SM), one transaction engine (TE) and one storage group. It currently has no user data in it. Take some time to explore the NuoDB Automation Console. For example, you can click on the
test database to get a description of it:
test is running in one region, with two processes on one host. It is using the Single Host template and is actively running. Click 2 Processes to display information about the database's processes:
There are two processes running. One process is a storage manager (SM) and one process is a transaction engine (TE).
In the top right corner, click the yellow disk icon to create the
nuodb_system database. The familiar Create Managed Database dialog appears. Enter the password you entered during installation. If you have forgotten this password then you can obtain it from the
NUODB_HOME/etc/default.properties file. In that file, the setting of the
domainPassword property is the password you need to enter. After the
nuodb_system database is created, it stores metrics for all hosts, databases and processes in the domain. To view these metrics, click Dashboard in the upper left side of the Automation Console. You can see data for CPU and memory. For details, see Obtaining Metrics for the Domain, Hosts and Processes.