I am developing a PHP web application where all data is to be stored in a MySQL database but unfortunately have no server on which to upload it to and even if I did I will be working offline quite a bit. My question is how to set up a database for free using a normal install process (I don't have sudo privileges in the terminal but can type in administrator password to install or download) that doesn't use up a ton of storage. To be clear, I do not need a massive database in which to store tons of data, I will be clearing it and resetting it to test various features all the time.
MySQL offers pre-built macOS installers. You can find them here.