Forum Discussion
Issue connecting to mysql server
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?
3 Replies
- amitchandak
Super User
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
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.
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
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.
