Providing credentials with cqlsh

Typically, after configuring authentication, logging into cqlsh requires the -u and -p options to the cqlsh command. To set credentials for use when launching cqlsh, create or modify the .cassandra/cqlshrc file. When present, this file passes default login information to cqlsh. See the cqlshrc.sample.

Procedure

Create or modify the cqlshrc file that specifies a role name and password.
```
[authentication]
username = fred
password = !!bang!!$
```
Save the file in <home>/.cassandra directory and name it cqlshrc.
Set permissions on the file to prevent unauthorized access, as the password is stored in plain text. The file must be readable by the user that starts cassandra.
```
chmod 440 <home>/.cassandra/cqlshrc
```
Check the permissions on <home>/.cassandra/cqlshrc_history to ensure that plain text passwords are not compromised.

Providing credentials with cqlsh

Procedure

Was this helpful?

Give Feedback