we couldn't authenticate with the credentials provided to connect to MySQL tcp/ip host server

[Becks]

Hi there,

I have tried to connect to MySQL with a TCP/IP host server, but it shows the error message "we couldn't authenticate with the credentials provided". The connection details work in MySQL Workbench, and the "Data source settngs" has set up as "Global permissions".  Doesn't Power BI support connecting to a TCP/IP host server?

[v-stephen-msft · Accepted solution]

Hi @Becks ,

Try to enter the network hostname only, the database name in the MySQL database connector to connect to MySQL.

Connecting MySQL to Power BI: A Comprehensive Guide

Best Regards,

Stephen Tao

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