Cannot connect to MySQL database with ODBC and Native connection

Question

I am able to connect to Mysql via ODBC and all of a sudden now I am unable to fetch data from tables (I can see tables).

Later I installed new connector from the link provided in Microsoft Power BI documents

Now I am unable to connect through native connection as well

I have enabled database credentials in the below settings.

file- options and settings- data source settings

v-chuncz-msft · Answer

vinoddevathi,
&nbsp;
Make sure you've started the MySQL service.

vinoddevathi · Answer

I have started MySQL services. But, whenever I try to connect to MySQL server then automatically services are stopped.

Hence, I need to start manually(i.e in service.msc).

Then Whenever I try to connect then it is the same issue (MySQL services will go down in server).

v-chuncz-msft · Answer

vinoddevathi,
&nbsp;
You may check MySQL Server Logs and reach out to https://forums.mysql.com/.

vinoddevathi · Answer

HI&nbsp;v-chuncz-msft,&nbsp;I am not able to fing Mysql logs. Is there any default path where we can check for logs.

v-chuncz-msft · Answer

vinoddevathi,
&nbsp;
This might be more related to MySQL.

Forum Discussion