Connect to data source if no password

[jaspercatapang]

Describe the bug
I cannot connect to our local database when it really doesn't have a password in the first place. Is a password really needed for WrenAI data source connection or does it require modification to accept a "passwordless" setup?

Expected behavior
I was expecting for it to go through with the connection but it's requiring the password.

Screenshots

Desktop (please complete the following information):

• OS: Mac OS Sonoma 14.6.1
• Browser: Chrome

Wren AI Information

• Version: 0.13.2
• LLM_PROVIDER= # openai_llm
• GENERATION_MODEL= # gpt-4o

Additional context
N/A

Relevant log output
N/A

[wwwy3y3]

@jaspercatapang thanks for the report!

[devansh-m12]

@wwwy3y3 i would like to work on this issue please assign me

[wwwy3y3]

@devansh-m12 assigned. thanks!

btw, you should also check if other data sources have the same problem, not just MySQL in the screenshot provided.

[jaspercatapang]

Thank you for the speedy response @wwwy3y3 and @devansh-m12. As a workaround, we just created a new user with a password for testing purposes.