I am currently in the process of setting up a database in MySQL for an application where I will be running PowerBI to do analyses on the data in the database and in a further stage to design an application to upload/download data from this db.
I tried to install the 126.96.36.199 Community Edition through the MySQL Installer. I installed MySQL Server, Shell, Workbench and the ODBC Connector (I want to use Access as a front end) and the NET Connector (I want to import the data in PowerBI). Furthermore I choose to not have MySQL running as a Windows Service as it would keep running in the background. I am currently using my machine with limited hardware resources both as a host and a client. We don't have dedicated infrastructure yet and I am purely using my machine to test/develop.
What I would like to be able to do is the following: starting the server instance through MySQL Workbench when working on the project, open Microsoft Access and PowerBI to work on both the reports and the database. After finishing, I would stop the server instance again through MySQL Workbench.
Does anyone know wha I am doing wrong? Did I not install enough packages to get it running or did I configure someting wrong?
Thanks in advance!