Providing credentials with cqlsh
Typically, after configuring authentication, logging into cqlsh requires the -u and -p options to the
To set credentials for use when launching
cqlsh, create or modify the .cassandra/cqlshrc file.
When present, this file passes default login information to
See the cqlshrc.sample.
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
chmod 440 <home>/.cassandra/cqlshrc
Check the permissions on <home>/.cassandra/cqlshrc_history to ensure that plain text passwords are not compromised.