Using cqlsh with authentication
Create or modify the
cqlshrcfile that specifies a role name and password.
[authentication] username = fred password = !!bang!!$
Save the file in
home/.cassandradirectory and name it
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_historyto ensure that plain text passwords are not compromised.