Connecting from the administration tools

You can use the to connect to a database using vsql on any node in the cluster.

You can use the Administration tools to connect to a database using vsql on any node in the cluster.

Log in as the database administrator user; for example, dbadmin.

Note
Vertica does not allow users with root privileges to connect to a database for security reasons.
Run the Administration Tools.
```
$ /opt/vertica/bin/admintools
```
On the Main Menu, select Connect to Database.
If prompted, enter the database password:
```
Password:
```
When you create a new user with the CREATE USER command, you can configure the password or leave it empty. You cannot bypass the password if the user was created with a password configured. You can change a user's password using the ALTER USER command.

The Administration Tools connect to the database and transfer control to vsql.

Welcome to vsql, the Vertica Analytic Database interactive terminal.
Type:  \h or \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit

=>

Note

See Meta-commands for the various commands you can run while connected to the database through the Administration Tools.