clickhouseCreate new user
CREATE USER user1 HOST IP '127.0.0.1' IDENTIFIED WITH sha256_password BY 'pwd';ctrl + c| CREATE USERcreate new user | user1name of the user to create | 
| 127.0.0.1allow access from localhost only | pwdpassword to user for new user | 
Usage example
CREATE USER user1 HOST IP '127.0.0.1' IDENTIFIED WITH sha256_password BY 'pwd';output
Query id: bbc7641a-e510-4327-b90c-84a0d52ddbb4
Ok.
0 rows in set. Elapsed: 0.001 sec.