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%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%3CLINGO-SUB%20id%3D%22lingo-sub-1881814%22%20slang%3D%22en-US%22%3ERe%3A%20MySQL%20Connection%20from%20Excel%20in%20Office%20365%20ProPlus%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1881814%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F397086%22%20target%3D%22_blank%22%3E%40adare87%3C%2FA%3EDepending%20on%20how%20MySQL%20was%20installed%2C%20it%20may%20no%20longer%20be%20possible%20to%20access%20the%20root%20account%20with%20the%20username%20and%20password.%20I'd%20suggest%20you%20create%2Fuse%20an%20alternate%20username%20%26amp%3B%20try%20again%20to%20get%20around%20that%20security%20enhancement%20to%20MySQL.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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? 

 

1 Reply

@adare87Depending on how MySQL was installed, it may no longer be possible to access the root account with the username and password. I'd suggest you create/use an alternate username & try again to get around that security enhancement to MySQL.