如何重置丢失的Cassandra管理员用户的密码？ [英] How to reset a lost Cassandra admin user's password?

问题描述

我可以完全访问Cassandra安装文件和在 cassandra.yaml 中配置的PasswordAuthenticator。

I have full access to the Cassandra installation files and a PasswordAuthenticator configured in cassandra.yaml. What do I have to do to reset admin user's password that has been lost, while keeping the existing databases intact?

推荐答案

我已经解决了这个问题，我需要做什么才能重置已丢失的管理员用户密码？以下步骤：

Solved with the following steps:

1. 将 cassandra.yaml 中的验证者更改为AllowAllAuthenticator，然后重新启动Cassandra


2. cqlsh


3. update system_auth.credentials set salted_hash =' $ 2a $ 10 $ vbfmLdkQdUz3Rmw.fF7Ygu6GuphqHndpJKTvElqAciUJ4SZ3pwquu'where username ='cassandra';


4. 退出 cqlsh li>
   
5. 将验证码更改回PasswordAuthenticator并重新启动Cassandra

1. Change authenticator in cassandra.yaml to AllowAllAuthenticator and restart Cassandra
2. cqlsh
3. update system_auth.credentials set salted_hash='$2a$10$vbfmLdkQdUz3Rmw.fF7Ygu6GuphqHndpJKTvElqAciUJ4SZ3pwquu' where username='cassandra';
4. Exit cqlsh
5. Change authenticator back to PasswordAuthenticator and restart Cassandra

现在您可以使用

cqlsh -u cassandra -p cassandra

并将密码更改为其他内容。

and change the password to something else.

这篇关于如何重置丢失的Cassandra管理员用户的密码？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！