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!