Creating a database and users

The admintools utility included in the installation provides a number of administrative functions.

The admintools utility included in the installation provides a number of administrative functions. The following steps show how to create a database and users with this utility.

View the status of your cluster. It should return an empty table.

$ admintools -t view_cluster

 DB | Host | State
----+------+-------

Create a database called "vdb" in the home directory with the password "vertica". This command also sets the plaintext password "vertica" for both the database and dbadmin.
```
$ admintools -t create_db --data_path=/home/dbadmin --catalog_path=/home/dbadmin --database=vdb --password=vertica --hosts=localhost
```
Run vsql and enter "vertica" at the password prompt.
```
$ vsql
```
Create a user named "Mike" with the password "inventor."
```
=> CREATE USER Mike IDENTIFIED BY 'inventor';
```

Grant the USAGE permission on the public schema.

=> GRANT USAGE ON SCHEMA PUBLIC TO Mike;

Load sample data.