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

Copper Contributor

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!  

0 Replies