Unable to connect to Mysql DB server .

[romals29]

Hi

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

[romals29 · Accepted solution]

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. 

[lbendlin]

Uninstall the 8.0.29 driver and install 8.0.28 instead

[romals29]

Hi Ibendlin

Will this solve my problem?

May I know what's the reason 

Thank You

[lbendlin]

MySQL Bugs: #107316: MySQL 8.0.29 introduces a bug which prevents use of the Connector software

[romals29]

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 

[lbendlin]

That is correct, Power BI needs a direct connection to the data source. It can be encrypted but it can't be tunnelled. 

[romals29]

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

[v-jingzhang]

Hi @romals29 

Currently Power BI desktop doesn't support SSH setting for MySQL database. You can vote up a related idea at MySQL over SSH connection . In addition, a user provided a solution with ODBC driver in comment area on that idea's page, you can give it a try. 

Best Regards,
Community Support Team _ Jing

[romals29]

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

[lbendlin]

I am not aware of any way to avoid the direct connection requirement.  Short of setting up a VPN that is on all the time.