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://*.com/questions/29121904/cassandra-cqlsh-connection-refused
Synopsis
On a Linux host:
bin/cqlsh [options] [host [port]]
On a Windows host:
python cqlsh.py [options] [host [port]]
windows下直接python cqlsh.py加上host port即可！