hello - i originally asked this question here but it was never answered.
i have my steps to install CR 1.1.6 and create a user, but for some reason i am able to locally connect to CR without being prompted for the password:
cockroach sql --user=markedwards --database=bank --certs-dir=./path-to-certs-directory/ ;
here is a gist i wrote to demonstrate the behavior: https://gist.github.com/edwardsmarkf/68e39b83fab131d52b91a29bca1a79a0
please note that the password is indeed required to connect remotely (as expected), but not locally.
thank you very much.