Cannot Connect to MySQL Database

[akwang]

Hi What would be my server name?

i tried localhost, localhost:3306 and still unable to connect.

[Greg_Deckler]

Last time I had an issue connecting to MySQL with Power BI, I had to make sure that I was not trying to use Windows credentials but rather database credentials. And it looks like localhost is your server name.

[akwang]

hi smoupre,

i did that and still i cannot connect.

[Eric_Zhang · Accepted solution]

---

@akwang wrote:

hi smoupre,

i did that and still i cannot connect.

---

@akwang

For above error, please ensure that you've specified the correct server name, it could be servierIP:portNo("10.157.19.199:3306") or ServerName. Also ensure that the MySQL Service is running on the server you're connecting to.

[wildmight2017]

I can recommend setting up ODBC driver on the machine running mysql - such as  https://dev.mysql.com/downloads/connector/odbc/5.3.html 

[akwang]

Any tutorial on how to use the ODBC?