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
Highlighted
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
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies
Dont see any Contact in Teams
nicb in Microsoft Teams on
2 Replies
No setting default margins?
listondavis in Excel on
5 Replies
OUTLOOK JUNK FOLDER DUPLICATION BUG
Phil Gibbs in Office 365 on
1 Replies