Error when connecting to MYSQL using Maria DB using Power BI desktop

[gubhare]

Hi Anyone 

came across this error while connecting to mysql using Mariadb ODBC connector for power bi?

Here is the error i get

[ma-3.1.20]TLS/SSL error: no cipher match. Error 0x80090331(SEC_E_ALGORITHM_MISMATCH)

Any help would be appreciated 

[amitchandak]

@gubhare , Make sure you have installed the latest .net driver.

https://dev.mysql.com/downloads/connector/net/

Also, your ip should have access to the DB 

[gubhare]

Hi Amit,

Thanks for your reply. 

I have installed the latest version of the connector which is 9.1.0

The Maria db connector version i have installed is 3.1.2

Also, your ip should have access to the DB - does this mean i need to create a user in the db with the IP address ?