Enable Cassandra Authentication

January 22, 2020

Enable Cassandra Database Authentication

Edit cassandra.yaml

nano /etc/cassandra/cassandra.yaml

Set authenticator to PasswordAuthenticator

authenticator: PasswordAuthenticator

Restart the service

Use default super user to log into cqlsh

cqlsh -u cassandra -p cassandra

Create a new super user

CREATE ROLE prod WITH SUPERUSER = true AND LOGIN = true AND PASSWORD = 'prod';

Disable default super user

ALTER ROLE cassandra WITH SUPERUSER = false AND LOGIN = false;