I'm using Pandas to read data from TDengine. I have a new user 'dbuser'.
My code is:
import pandas
from sqlalchemy import create_engine
engine = create_engine("taos://dbuser……")
df: pandas.DataFrame = pandas.read_sql("select * from logs", engine)
However, it reports that I don't have permission. But when I try root user, it's ok,like
engine = create_engine("taos://root:taosdata@localhost:6030/log")
I tried different ways,such as
connection = taos.connect(database="power",user="dbuser",password="....")
It's ok.
So the user information and password are ok.
The version of TDengine is 3.0.1.5.
Did I miss some steps?