module 'vanna' has no attribute 'connect_to_mysql'

[Abhinav0905]

Describe the bug
unable to connect to MySQL. When printing the directory of Vanna, connect_to_mysql wasn't listed.
Even tried using pip install vanna[mysql]

To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Error logs/Screenshots
If applicable, add logs/screenshots to give more information about the issue.

Desktop (please complete the following information where):

• OS: [Windows]
• Version:
• Python: [3.12
• Vanna: [2.8.0]

Additional context
Add any other context about the problem here.

[zainhoda]

Upgrade your vanna installation please

pip install -U vanna

[Abhinav0905]

Tried doing on the vanna colab official page . Still facing the same issue

[Abhinav0905]

even tried like this --

[zainhoda]

Ah it's the "import vanna as vn" that's the issue. That's deprecated.

Try this setup to instantiate vn as a class:

https://vanna.ai/docs/mysql-openai-standard-chromadb/

[zainhoda]

@Abhinav0905 read this. You need way more training than what you’ve shown. https://vanna.ai/docs/training-advice/

[Abhinav0905]

Thanks for the response. Yeah agreed, it needs more training and I will do that. My problem is that it is not even able to read the database table names which I think is a straightforward thing. My db contains 6 tables and it is MYsql, whereas in the response I am getting sqlite_master with 11 tables.

[zainhoda]

@Abhinav0905 for that specific issue can you try doing this:

vn.dialect = ‘MySQL’

If that helps please report back.

[Mioooooo]

@Abhinav0905 I have never encountered this kind of situation, and it stands to reason that such an incident will not happen. This may be related to the running environment. Is your current running environment local or colab?

[Abhinav0905]

@Mioooooo I am running it on my local.