Forum Discussion

adare87's avatar
adare87
Copper Contributor
Aug 22, 2019

MySQL Connection from Excel in Office 365 ProPlus

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 h...
excel
MySQL database
office 365
anderm8's avatar
anderm8
Copper Contributor
Nov 12, 2020

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.

Resources