Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
akwang
Helper II
Helper II

Cannot Connect to MySQL Database

‎10-11-2017 04:09 AM

Hi What would be my server name?linden.jpg

 

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

Labels:
Message 1 of 6
16,725 Views
0
1 ACCEPTED SOLUTION
Eric_Zhang
Employee
Employee
In response to akwang

‎10-12-2017 11:06 PM
@akwang wrote:

hi smoupre,

 

i did that and still i cannot connect.

 

Screenshot_1.jpgScreenshot_2.jpg

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

Capture.PNG

View solution in original post

Message 6 of 6
17,871 Views
0
5 REPLIES 5
Greg_Deckler
Super User
Super User

‎10-11-2017 05:25 AM

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Message 2 of 6
16,716 Views
0
akwang
Helper II
Helper II
In response to Greg_Deckler

‎10-11-2017 07:40 AM

hi smoupre,

 

i did that and still i cannot connect.

 

Screenshot_1.jpgScreenshot_2.jpg

Message 3 of 6
16,708 Views
0
Eric_Zhang
Employee
Employee
In response to akwang

‎10-12-2017 11:06 PM
@akwang wrote:

hi smoupre,

 

i did that and still i cannot connect.

 

Screenshot_1.jpgScreenshot_2.jpg

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

Capture.PNG

Message 6 of 6
17,872 Views
0
wildmight2017
Advocate II
Advocate II
In response to akwang

‎10-11-2017 07:46 AM

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

Message 4 of 6
16,705 Views
0
akwang
Helper II
Helper II
In response to wildmight2017

‎10-11-2017 09:44 AM

Any tutorial on how to use the ODBC?

Message 5 of 6
16,697 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All