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 datetime to unix timestamp
- Convert hex to text
- Select countIf usage example
- Add row number to results
- Create table example
- String concat
- List all tables from all database
- Select rows with certain value in array column
- Insert array of strings in CSV format
- Select where date column is between dates
See more codes...