I have remote mysql DB server and I am trying to connect in power bi desktop and getting below error.
Details: "MySQL: Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server"
It shows my public ip and saying its not allowed, but I can connect in Mysqlworkbench.
May you please help me to fix this.
Thank You
Romal
Message of 11
1,508 Views
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Report Inappropriate Content
08-04-2022 03:45 AM
Hi All
I have found the solution for this.
1. creating AWS instance in the remote server that would allow to have direct connection but this may cost you in future.
2. Creating and granting full access to the public ip address that blocking you. If you are using your own network then should access through the VPN.
Message of 11
1,358 Views
- All forum topics
- Previous Topic
- Next Topic
10 REPLIES 10
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Report Inappropriate Content
08-04-2022 03:45 AM
Hi All
I have found the solution for this.
1. creating AWS instance in the remote server that would allow to have direct connection but this may cost you in future.
2. Creating and granting full access to the public ip address that blocking you. If you are using your own network then should access through the VPN.
Message of 11
1,359 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Report Inappropriate Content
07-31-2022 09:25 PM
Hi Ibendlin
As I checked I haven't installed 8.0.29 driver on my machine.
Anyhow I installed MySQL Connector Net8.0.28 driver and tried but still no luck
In workbench I have done SSH set up but in power bi, we don't have the facility to do SSH setting. Is this causing the issue? If so how to fix it?
Thank you
Message of 11
1,414 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Report Inappropriate Content
08-01-2022 04:42 AM
Hi Ibendlin
Thank you for the reply.
In that case we can't use SSH tunnelling in power bi but in my case our DB server is configured in the way to access to SSH.
May you please help me to find a workaround for this.
Thank You
Romal
Message of 11
1,402 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Report Inappropriate Content
08-02-2022 03:02 AM
Hi
I have some grey areas on this. Please clarify me on below two concerns.
I set up the putty connection and set as localhost:3306 in destination.
1. When I set up the ODBC when I give localhost under TCP/IP then it refers my already existing local DB not the remote server that I set in the putty.
2. Next issue is how this will work when I publish the reports to the server? Everytime should I keep maintain the putty connection on my local?
Thank You
Message of 11
1,375 Views
Helpful resources
Fabric Community Update - June 2024
Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.