Issue connecting to mysql server

[Anonymous]

Hello World,

Let me explain my problem in detail. I'm currently using a Macbook with M1 chip and trying to build some reports using PBI. I'm trying to connect MySql server hosted on GCP.

I'm using parallels to host windows on my local machine and install the rest. Due to security issues I can not open a firewall and i'll have to use a port forwarding to Windows VM. Setup seems fine and I can connect using Dbeaver to the MySql Database.

The real issue is when I'm trying to connect using the the inbuilt connector. It throws an authentication error. 

below are my inputs:

server: localhost:2222

databse: Zulupi

next page it takes me to the auth screen and i enter the credentials and it throws an error saying invalid auth. 

any solution to this?

[Anonymous]

Hi  @Anonymous ,

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/Connect-mysql-database-problem/m-p/1935139

https://community.powerbi.com/t5/Power-Query/Problem-connecting-with-mysql/m-p/333488

https://community.powerbi.com/t5/Desktop/We-couldn-t-authenticate-with-the-credentials-provided-Please/td-p/1062732

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Localhost means you are having MySQL or windows, to you have created a tunnel between VM and MAc, There is an option to allow passing of a port request to host OS, in VM setup 

[Anonymous]

Hello @amitchandak  thanks for the response, I checked for the settings. I previously had recomended setting just to validate i changed it to host only but still no luck.