You need to edit cassandra.yaml on the node you are trying to connect to and set the node ip address for rpc_address and listen_address and restart Cassandra.

rpc_address is the address on which Cassandra listens to the client calls.

listen_address is the address on which Cassandra listens to the other Cassandra nodes.

Try to change the rpc_address to point to the node's IP instead of 0.0.0.0 and specify the IP while connecting to the cqlsh, as if the IP is 10.0.1.34 and the rpc_port left to the default value 9160 then the following should work:

cqlsh 10.0.1.34 9160 

Or:

cqlsh 10.0.1.34 


见：http://stackoverflow.com/questions/29121904/cassandra-cqlsh-connection-refused

Synopsis 

On a Linux host:

bin/cqlsh [options] [host [port]]

python cqlsh.py [options] [host [port]] 

windows下直接python cqlsh.py加上host port即可！