Reset Authenticator Password

This procedure describes what to do when a user loses his password and can not reset it with a superuser role. The procedure requires cluster downtime and as a result, all of the system_auth data is deleted.

Procedure

1. Stop Scylla nodes (Stop all the nodes in the cluster).
sudo systemctl stop scylla-server
2. Remove your tables under /var/lib/scylla/data/system_auth/.
rm -rf /var/lib/scylla/data/system_auth/
3. Start Scylla nodes.
sudo systemctl start scylla-server
4. Verify that you can log in to your node using cqlsh command.
The access is only possible using Scylla superuser.
cqlsh -u cassandra -p cassandra
5. Recreate the users

Troubleshoot