clickhouseCreate new user
CREATE USER user1 HOST IP '127.0.0.1' IDENTIFIED WITH sha256_password BY 'pwd';ctrl + cCREATE 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.More of Clickhouse
- Convert array to rows
- How to execute SQL query from a file
- Get total database size
- How to restart Clickhouse server
- Select where date column is between dates
- List all tables from all database
- Using variables in queries
- Select sumIf query example
- Convert array to string
- Select countIf usage example
See more codes...