Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-307695%22%20slang%3D%22en-US%22%3Eunable%20to%20connect%20to%20mysql%20using%20Get%20Data%20in%20Office%20365%20Pro%20Plus%20v%201812%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307695%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20past%20I%20was%20able%20to%20connect%20to%20a%20MySql%20database%20using%20%22Get%20Data%22%20%26gt%3B%20%22From%20Database%22%20%26gt%3B%20%22From%20MySql%20Database.%22%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20However%20now%20I%20receive%20an%20error%20message%20stating%20%22unable%20to%20authenticate.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20DB%20is%20an%20AWS%20MySql%20which%20I%20can%20connect%20to%20using%20Workbench%20for%20MySql%2C%20so%20I%20know%20that%20the%20credentials%20are%20correct.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20not%20that%20I%20am%20NOT%20using%20the%20Addon%20MySql%20for%20Excel.%26nbsp%3B%26nbsp%3B%20I'm%20using%20the%20new%20built-in%20feature.%26nbsp%3B%20Also%2C%20I%20have%20installed%20the%20OBDC%20and%20NET%20connectors%20from%20the%20official%20MySql%20site.%20%26nbsp%3B%20%26nbsp%3B%20Any%20ideas%20why%20I%20can't%20connect%3F%26nbsp%3B%20Could%20it%20be%20a%20permissions%20issue%20with%20AWS%3F%20%26nbsp%3B%20Thanks!%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-307695%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
demilly
Occasional Visitor

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!  

Related Conversations
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies