cloudflare / sqlalchemy-clickhouse

Apache License 2.0
314 stars 105 forks source link

user is not work #53

Closed langchao209 closed 4 years ago

langchao209 commented 4 years ago

Hi, I connect clickhouse like this:

import sqlalchemy as sa
import pandas as pd
engine =  sa.create_engine('clickhouse://random_name:@localhost:8123/default')
sql = "show databases"
df = pd.read_sql(sql, engine) 

The user can be anything that has not been created in clickhouse. Any random names can connect to clickhouse as the default user.
I have created a readonly user, but it did not work

langchao209 commented 4 years ago

I found the answer here #49