Connecting From the Administration Tools

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

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

    Vertica does not allow users with root privileges to connect to a database for security reasons.

  2. Run the Administration Tools.

    /opt/vertica/bin/admintools

  3. On the Main Menu, select Connect to Database.

  4. Supply the database password if asked:

    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.

  5. 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
    
    =>

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