CockroachDB: set up database and user using the internal SQL client

cockroach-sql-init.sh

core@ip-10-0-7-99 ~ $ docker run -it cockroachdb/cockroach:beta-20160512 sql --host=10.0.7.99 --port=12504
# Welcome to the cockroach SQL interface.
# All statements must be terminated by a semicolon.
# To exit: CTRL + D.
root@10.0.7.99:12504> CREATE DATABASE bank;
CREATE DATABASE
root@10.0.7.99:12504> show databases;
+----------+
| Database |
+----------+
| bank     |
| system   |
+----------+
root@10.0.7.99:12504> GRANT ALL ON DATABASE bank TO maxroach;
GRANT