I am very new to cassandra database. I need to set up a username and password for the database ... Someone please help me explain how to do this.
You can create users with passwords that have ro or rw access at the column family level. For Cassandra 0.7 or earlier, you can find it here: http://www.datastax.com/docs/0.7/configuration/authentication
For version 1.0 and later, authentication has been moved to the sample directory. You can find an example of how to configure it (as before): http://devblog.michalski.im/2012/04/05/adding-simple-authentication-to-cassandra/
In general, Cassandra developers seem to recommend isolating your Cassandra database through a firewall, relying on user / password authentication. If you can go this route, it is very important.
For added security, you can also encrypt the node connection: http://wiki.apache.org/cassandra/InternodeEncryption
Here are some more Cassandra permissions (after setting up authentication): http://devblog.michalski.im/2012/04/22/more-on-cassandra-simpleauthority-permissions/
, , CF.