Lots of questions. Setting up a MySQL server isn’t the simplest thing, there are a few steps, but it’s not too bad. I don’t know if using digikam requires you to do so. If it does, start by reading the relevant part of our MAMP page: https://trac.macports.org/wiki/howto/MAMP