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 https://go.microsoft.com/fwlink/?LinkId=278885 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?
MySQL in-app
I have a students starter subscription. For a class project, I need to create a MySQL database. When I tried that on Azure portal, I was required to upgrade, which I don't intend to do for now. I know my subscription package includes support for MySQL in-app. So what is this MySQL in-app all about if it doesn't allow me to create a MySQL database? I already went through plenty of documentation and didn't find a straight answer. Please, someone, help me understand what MySQL in-app provides and whether there is a work-around for me to create a MySQL database without upgrading. Thank you.
