Home

MySQL Connection from Excel in Office 365 ProPlus

%3CLINGO-SUB%20id%3D%22lingo-sub-818686%22%20slang%3D%22en-US%22%3EMySQL%20Connection%20from%20Excel%20in%20Office%20365%20ProPlus%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-818686%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can't%20get%20the%20MySQL%20connection%20to%20work%20in%20Excel%20Office%20365.%20By%20this%2C%20I'm%20talking%20about%20the%20built-in%20method%20accessed%20from%20Data%20%26gt%3B%20Get%20Data%20%26gt%3B%20From%20Database%20%26gt%3B%20From%20MySQL%20Database.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20installed%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkId%3D278885%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMySQL%20Connector%2FNet%206.6.5%20for%20Microsoft%20Windows.%3C%2FA%3E%3C%2FP%3E%3CP%3EThis%20didn't%20originally%20work%20when%20I%20downloaded%20version%208.0.17%2C%20but%20if%20I%20installed%208.0.16%20I%20did%20get%20a%20step%20further.%3C%2FP%3E%3CP%3EI'm%20asked%20to%20provide%20the%20Server%20Name.%20I'm%20putting%20localhost.%3C%2FP%3E%3CP%3EIt%20then%20asks%20for%20credentials%2C%20and%20I%20select%20%22use%20alternate%20credentials%22%20and%20try%20to%20put%20in%20my%20MySQL%20credentials%2C%20e.g.%20username%20'root'%20and%20password%20as%20my%20password.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20getting%20an%20error%20though%20saying%20%22We%20couldn't%20authenticate%20with%20the%20credentials%20provided.%20Please%20try%20again%22.%3C%2FP%3E%3CP%3EThose%20credentials%20are%20the%20ones%20I%20can%20access%20MySQL%20with%2C%20so%20I%20don't%20know%20what%20I'm%20doing%20wrong.%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20tips%3F%3F%20Am%20I%20doing%20something%20wrong%20somewhere%3F%20Should%20my%20username%20be%20different%3F%20e.g.%20root%40localhost%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-818686%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMySQL%20database%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
adare87
Occasional Visitor

I can't get the MySQL connection to work in Excel Office 365. By this, I'm talking about the built-in method accessed from Data > Get Data > From Database > From MySQL Database.

 

I installed the MySQL Connector/Net 6.6.5 for Microsoft Windows.

This didn't originally work when I downloaded version 8.0.17, but if I installed 8.0.16 I did get a step further.

I'm asked to provide the Server Name. I'm putting localhost.

It then asks for credentials, and I select "use alternate credentials" and try to put in my MySQL credentials, e.g. username 'root' and password as my password. 

I'm getting an error though saying "We couldn't authenticate with the credentials provided. Please try again".

Those credentials are the ones I can access MySQL with, so I don't know what I'm doing wrong.

Does anyone have any tips?? Am I doing something wrong somewhere? Should my username be different? e.g. root@localhost? 

 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies