Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi What would be my server name?
i tried localhost, localhost:3306 and still unable to connect.
Solved! Go to Solution.
@akwang wrote:
hi smoupre,
i did that and still i cannot connect.
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.
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.
hi smoupre,
i did that and still i cannot connect.
I can recommend setting up ODBC driver on the machine running mysql - such as https://dev.mysql.com/downloads/connector/odbc/5.3.html
Any tutorial on how to use the ODBC?
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |