Cannot connect to MySQL database

[bisigreat]

Dear all,

Please I need help.

Power BI Desktop cannot connect to MySQL Database.

The error message is "The user was not authorized"

I have been on this for two weeks now.

Any help will be appreciated.

N/B: I have downloaded the latest MySQL connector but still have the same issue.

Regards,

Bisi.

[v-yulgu-msft]

Hi @bisigreat,

The first thing you need to check is the credential used to connect. Connections to MySQL from Power Query/Power BI Desktop tend to default to Windows credentials which often do not work with default installations of MySQL Server. To troubleshoot this issue, go to File ->Options and Settings -> Data source settings and edit your data source and set the credentials to "Database credentials” rather than Windows credentials. Reference: Power BI Tips for Working with MySQL

If you have confirmed the credential is correct,  this issue may be caused by the past connections on the same desktop application. In this scenario, you can follow this article to delete the cache and the old data source connections related.

If you have any question, please feel free to ask.

Best regards,
Yuliana Gu

[diiiiiiiit_]

Thank you so much. It works for me in Windows 10 64 bit

[Anonymous]

Clearing the cache worked for me, when I was having problems changing the credentials I was using to connect to an Azure SQL database. I could connect via SQL Server Management Studio no problems but not through Power BI using the Database option.

Cleared the cache, re-entered the data source details and credentials excatly as before and it worked.

[bisigreat]

Hi,

I have tried all the suggested options.

It is still showing me thesame error "The user was not authorized"

Thank you,

Bisi

[GeoSteven]

Did anyone ever get this to work. I am getting the same error when trying to connect to MySQL. I can connect using other interfaces (Toad) but PowerBI will not. 

[talisman3]

Hi

It looks like people have given up on the solution or have resolved the issue and withheld the detail 😞

I'm trying to connect ot MySQL hosted on Microsoft Azure by Cleardb, have tried all suggestions below, confirmed the connection details is exactly the same as MySQL Workbench which connects successfully.

Anyone figured why this happens and how to resolve it?

Thanks

[Greg_Deckler]

Make sure that you are using Database credentials and not Windows credentials.