Cannot connect to MySQL database with ODBC and Native connection

[vinoddevathi]

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

https://docs.microsoft.com/en-us/power-bi/desktop-data-source-prerequisites

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]

@vinoddevathi,

Make sure you've started the MySQL service.

[vinoddevathi]

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]

@vinoddevathi,

You may check MySQL Server Logs and reach out to https://forums.mysql.com/.

[vinoddevathi]

HI @v-chuncz-msft,

I am not able to fing Mysql logs. Is there any default path where we can check for logs.

[v-chuncz-msft]

@vinoddevathi,

This might be more related to MySQL.