Apache Cassandra™ 2.0

Logging in using cqlsh

To avoid having to pass credentials for every login using cqlsh, you can create a cqlshrc file in the .cassandra directory, which is in your home directory. When present, this file passes default login information to cqlsh.

Procedure

  1. Open a text editor and create a file that specifies a user name and password.
    [authentication]
    username = fred
    password = !!bang!!$
  2. Save the file in your home/.cassandra directory and name it cqlshrc.
  3. Set permissions on the file. To protect database login information, ensure that the file is secure from unauthorized access.
    Note: Sample cqlshrc files are available in:
    • Packaged installs

      /usr/share/doc/dse-libcassandra

    • Binary installs

      install_location/conf