How do I connect Mysql with pandasai

[in27sung]

I followed the below code but I've got an error this

Exception in APILogger: {"message":"Invalid API Key!","data":null}
Unfortunately, I was not able to answer your question, because of the following error:
Unauthorized

but I typed the api key correctly

import os
from pandasai import Agent
from pandasai.connectors import MySQLConnector

# With a MySQL database
loan_connector = MySQLConnector(
    config={
        "host": "localhost",
        "port": 3306,
        "database": "mydb",
        "username": "root",
        "password": "root",
        "table": "loans",
        "where": [
            # this is optional and filters the data to
            # reduce the size of the dataframe
            ["loan_status", "=", "PAIDOFF"],
        ],
    }
)

# By default, unless you choose a different LLM, it will use BambooLLM.
# You can get your free API key signing up at https://pandabi.ai (you can also configure it in your .env file)
os.environ["PANDASAI_API_KEY"] = "your-api-key"

agent = Agent([loan_connector])
response = agent.chat("How many people from the United states?")
print(response)

[gventuri]

Hi @in27sung which version are you using?