Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Can not connect to Mysql datababse

Hello All,

 

I am newbie to powerbi.

I am trying to connect mysql servers(5 servers) which are in centos systems from my local machine i.e windows power bi desktop.

we have mysql db's in multiple systems. Here i can connect some of the mysql servers, but some of them are not.

I have followed the same scenario while connecting to every mysql server.

Server name=hostname that the mysql server is(tried fqdn,ip and ip with defalut mysql port..non of them worked)

DB name=dbname

username = root

pasword= root

While connecting to mysql server, for some systems i am getting the error as

UNABLE TO CONNECT

Details: "MySQL: Unable to connect to any of the specified MySQL hosts."

For some system i am getting the error as

UNABLE TO CONNECT

Details: "MySQL: Host 'ip' is not allowed to connect to this MySQL server"

Every mysql server having the same configuration, same dbname except the server name.

But i can to some of them but not for some of them.

I tried to find out the solution for above errors, i found these links.

https://dev.mysql.com/doc/refman/5.5/en/problems-connecting.html

But i coudnt get what exactly to do.

Please suggest me.

Thanks in advance

Mohan.V

 

 

5 REPLIES 5
v-shex-msft
Community Support
Community Support

Hi @Anonymous,

 

>>Details: "MySQL: Unable to connect to any of the specified MySQL hosts."

This issue seem related to server, you can try to check the settings of your database server.(e.g. mysql service is off, input an unexist database)

 

>>Details: "MySQL: Host 'ip' is not allowed to connect to this MySQL server"

As smoupre said, it seems like to related to your computer setting, please check your settings.(e.g. port, firewall rule...)

 

Can you share some detail content of your issue? I test to connect mysql with server name and database mode success.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Thanks for the repley @v-shex-msft @Greg_Deckler.

I have tried by disabling firewall in my windows as well as the end user(centos 7) system. But still no luck.

Even i have tried by creating an another database, but still facing the same issue.

here i am providing the screenshot of that error.Mysql Error.PNG

 

Please suggest me how can i resolve this issue.

Mohan.V

 

Anonymous
Not applicable

@v-shex-msft can you please suggest me for the above.

Hi @Anonymous,

 

Did you try to add the port after the servername? It may cause the issue if your database not use the default port.

In addition, you can also check the mysql service if it has been turned off.

 

Regards,

XIaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Greg_Deckler
Super User
Super User

Looks like there is some kind of firewall or connection rule that only allows certain IP addresses to connect. This could be at the OS level or perhaps the MySQL level (not a MySQL expert).


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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