cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vinoddevathi Frequent Visitor
Frequent Visitor

Cannot connect to MySQL database with ODBC and Native connection

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).error2.png

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

Error.png

I have enabled database credentials in the below settings.

file- options and settings- data source settings 

 

 

5 REPLIES 5
Community Support Team
Community Support Team

Re: Cannot connect to MySQL database with ODBC and Native connection

@vinoddevathi,

 

Make sure you've started the MySQL service.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vinoddevathi Frequent Visitor
Frequent Visitor

Re: Cannot connect to MySQL database with ODBC and Native connection

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).

Community Support Team
Community Support Team

Re: Cannot connect to MySQL database with ODBC and Native connection

@vinoddevathi,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vinoddevathi Frequent Visitor
Frequent Visitor

Re: Cannot connect to MySQL database with ODBC and Native connection

HI @v-chuncz-msft,

 

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

Highlighted
Community Support Team
Community Support Team

Re: Cannot connect to MySQL database with ODBC and Native connection

@vinoddevathi,

 

This might be more related to MySQL.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.