Forum Discussion

demilly's avatar
demilly
Copper Contributor
Dec 31, 2018

unable to connect to mysql using Get Data in Office 365 Pro Plus v 1812

In the past I was able to connect to a MySql database using "Get Data" > "From Database" > "From MySql Database."      However now I receive an error message stating "unable to authenticate."

 

The DB is an AWS MySql which I can connect to using Workbench for MySql, so I know that the credentials are correct.

 

Please not that I am NOT using the Addon MySql for Excel.   I'm using the new built-in feature.  Also, I have installed the OBDC and NET connectors from the official MySql site.     Any ideas why I can't connect?  Could it be a permissions issue with AWS?   Thanks!  

No RepliesBe the first to reply

Resources