Friday 28 April 2017

Cassandra create new super user and change default user password

[root@garey-mysql1]# cqlsh 192.168.142.200 -u cassandra -p cassandra --cqlversion='3.4.2'
Connected to Test Cluster at 192.168.142.200:9042.
[cqlsh 5.0.1 | Cassandra 3.9.0 | CQL spec 3.4.2 | Native protocol v4]
Use HELP for help.
cassandra@cqlsh> create user dba01 with password 'P@ssw0rd123' superuser;
cassandra@cqlsh> quit
[root@garey-mysql1 default.conf]# cqlsh 192.168.142.200 -u dba01 -p P@ssw0rd123 --cqlversion='3.4.2'
Connected to Test Cluster at 192.168.142.200:9042.
[cqlsh 5.0.1 | Cassandra 3.9.0 | CQL spec 3.4.2 | Native protocol v4]
Use HELP for help.
dba01@cqlsh> alter user cassandra with password 'P@ssw0rd123' superuser;
dba01@cqlsh> list users;

 name      | super
-----------+-------
 cassandra |  True
     dba01 |  True

(2 rows)
dba01@cqlsh>

No comments:

Post a Comment